table数据导入到Excel js实现_$.table.importexcel()-优快云博客

本文介绍了一个用于生成财务报表的网页应用，并实现了通过JavaScript将报表数据导出为Excel文件的功能。该应用利用WebWork框架进行页面搭建，通过Java后台处理报表数据请求，实现了动态填充报表数据并提供报表导出功能。

<%@page contentType="text/html; charset=GBK"%> <%@page import="java.util.List"%> <%@page import="java.util.Map"%> <%@page import="com.opensymphony.xwork.ActionContext"%> <%@ taglib prefix="ww" uri="webwork" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <META http-equiv=Content-Type content="text/html; charset=gb2312"> <link rel="stylesheet" href="<%=request.getContextPath()%>/css/style_1.css" type="text/css"> <title>财务报表结果</title> <META content="MSHTML 6.00.2800.1578" name=GENERATOR> </HEAD> <mce:script language="javascript" src="<%=request.getContextPath()%></mce:script> <mce:script language="javascript" src="<%=request.getContextPath()%></mce:script> <mce:script language="javascript" src="<%=request.getContextPath()%></mce:script> <mce:script language="javascript" src="<%=request.getContextPath()%></mce:script> <mce:script language="javascript" src="<%=request.getContextPath()%></mce:script> <mce:script language="javascript"></mce:script> <body topmargin="0" class="body4" onload="init()"> <form name="myform" method="post"> <input type="hidden" name="common_menu_id" value="<ww:property value="common_menu_id"/>"> <input type="hidden" name="level" value="<ww:property value="level"/>"> <input type="hidden" name="department_id" value="<ww:property value="department_id"/>"> <input type="hidden" name="identifier" value="<ww:property value="identifier"/>"> <input type="hidden" name="sign" value="<ww:property value="sign"/>" id="sign"> <input type="hidden" name="project_ids" value="<ww:property value="project_ids"/>" id="project_ids"> <center> <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="bg_lead_22"> <tr height="20" align="" > <td height="20" class="bg_lead_l"> <ww:property value="project_name"/></td> <td align="right"><input type="button" name="button2" class="new2" value="Excel导出" onClick="printTable(mytable)"> </td> </tr> </table> <table width="80%" border="0" cellspacing="0" cellpadding="0" class="table_g1" align="center"> <tr class="bg_w" height="60" align="center" > <td height="40" align="center"><p size="40" >报表统计</p></td> </td> </tr> </table> <table width="100%" border="0" cellspacing="1" cellpadding="1" class="table_g1" align="center" id="mytable">  <tr class="bg_w" height="26" align="center" > <td height="15"></td> <ww:iterator value="dept_List" status="rowstatus1"> <td height="15" valign="top"> <input id="dept_<ww:property value="#rowstatus1.index"/>" value="<ww:property value="id"/>" type="hidden"/ > <input style="border-width:0px;height: 1" readonly size="30"> <ww:property value="name"/> </td> </ww:iterator> <td valign="top"> <input style="border-width:0px;height: 1" readonly size="30"> 小计:</td> </tr> <ww:iterator value="type_view_List" status="rowstatus2"> <tr class="bg_w" height="26" align="center"> <td height="15" valign="top"> <input id="type_<ww:property value="#rowstatus2.index"/>" type="hidden" value="<ww:property value="id"/>" /> <input style="border-width:0px;height: 1" readonly size="30"> <ww:property value="name"/> </td> <ww:iterator value="dept_List" status="rowstatus3"> <td height="15"> <input id="value_<ww:property value="#rowstatus3.index"/>_<ww:property value="#rowstatus2.index"/>" style="border-width:0px;" value=""> </td> </ww:iterator> <td > <input id="" style="border-width:0px;" mce_style="border-width:0px;" value=""> </td> </tr> </ww:iterator> <tr class="bg_w" height="26" align="center"> <td height="15" > <input style="border-width:0px;height: 1" readonly size="30"> 小计: </td> <ww:iterator value="dept_List" status="rowstatus3"> <td height="15"> <input id="value_<ww:property value="#rowstatus3.index"/>_<ww:property value="#rowstatus2.index"/>" style="border-width:0px;" value=""> </td> </ww:iterator> <td ><input style="border-width:0px;height: 1" readonly size="30"> 总金额：<div id="total_Amount"></div> </td> </tr> </table> </center> </form> </body> </html>