有没有办法将当前页面中table的内容直接转成excel供客户端使用？？？

转到该页面的时候，同时把table中的值写到excel中就可以了

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

<%@ page
language="java"
contentType="application/msexcel;charset=GBK"
%>
<%
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires", 0);
%>
<%
/***************************************************************************
程序名称:生成Excel功能
功能描述:评价统计
作   者:easydozer
日   期:2004-3-4
***************************************************************************/
//程序处理区开始//程序处理区结束String saveFileName = "评价统计";
response.setHeader("Content-Disposition","attachment;filename="+saveFileName+".xls");
%>
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40"><head>
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<link rel=File-List href="./Book1.files/filelist.xml">
<link rel=Edit-Time-Data href="./Book1.files/editdata.mso">
<link rel=OLE-Object-Data href="./Book1.files/oledata.mso">

<style>

</style>

</head><body link=blue vlink=purple><%
//现在开始输出表格数据,表格数据尽量简单,少使用格式
%>
<%//.......................%>
<%
//输出数据结束
%></body></html>
我的页面如下：
<%@ taglib uri="/WEB-INF/struts-tiles.tld" prefix="tiles" %>
<%@ taglib uri="/WEB-INF/struts-nested.tld" prefix="nested" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/struts-template.tld" prefix="template" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ page import="com.trademis.web.reportBean.ProductSaleReport,java.math.BigDecimal,java.lang.Double,java.text.DecimalFormat" %>
<%@ page contentType="application/vnd.ms-excel;charset=GBK" %>
<%int i=1;%>
<%
DecimalFormat dfAmount = new DecimalFormat("#.000");
    DecimalFormat dfMoney = new DecimalFormat("#.00");
double sumAmountInto =0;
double sumAmountSale =0;
        double sumAmountAllocateInto =0;
        double sumAmountAllocateSale =0;
        double sumQuantity =0;
%>
<html:html>
<head>
<title>
产品销售数量统计
</title>
</head>
<body>
<table width="100%"  class="tablebg" align="center" cellpadding="3" cellspacing="1">
  <caption>产品销售数量统计</caption>
  <tr class="tabletitle">
    <td>序号</td>
    <td>产品</td>
    <td>累计收入</td>
    <td>销售数量</td>
    <td>调入</td>
    <td>调出</td>
    <td>实际库存</td>
  </tr>
  <logic:iterate name="LogList" id="log" scope="request" type="com.trademis.web.reportBean.ProductSaleReport">
  <%
double amountInto =Double.parseDouble(((ProductSaleReport)log).getAmountInto());
        double amountSale=Double.parseDouble(((ProductSaleReport)log).getAmountSale());
        double amountAllocateInto=Double.parseDouble(((ProductSaleReport)log).getAmountAllocateInto());
        double amountAllocateSale=Double.parseDouble(((ProductSaleReport)log).getAmountAllocateSale());
        double quantity=Double.parseDouble(((ProductSaleReport)log).getQuantity());%>
  <tr>
    <td class="tableCenter"><%=i++%></td>
    <td class="tableCenter"><bean:writeTrans dictionary="ProductInfo" name="log" property="productCode"/></td>
    <td class="tableLeft"><div align="right"><bean:write name="log" property="amountInto" formatKey="format.money"/></div></td>
    <td class="tableLeft"><div align="right"><bean:write name="log"   property="amountSale" formatKey="format.money"/></div></td>
    <td class="tableLeft"><div align="right"><bean:write name="log"   property="amountAllocateInto" formatKey="format.money"/></div></td>
    <td class="tableLeft"><div align="right"><bean:write name="log"   property="amountAllocateSale" formatKey="format.money"/></div></td>
    <td class="tableLeft"><div align="right"><bean:write name="log"   property="quantity" formatKey="format.money"/></div></td>
    <%
sumAmountInto +=amountInto;
sumAmountSale +=amountSale;
        sumAmountAllocateInto +=amountAllocateInto;
        sumAmountAllocateSale +=amountAllocateSale;
        sumQuantity +=quantity;
%>
  </tr>
  </logic:iterate>
  <tr>
    <td class="tableCenter"></td>
    <td class="tableCenter">合计</td>
    <td class="tableLeft"><%=dfAmount.format(sumAmountInto)%></td>
    <td class="tableLeft"><%=dfAmount.format(sumAmountSale)%></td>
    <td class="tableLeft"><%=dfAmount.format(sumAmountAllocateInto)%></td>
    <td class="tableLeft"><%=dfAmount.format(sumAmountAllocateSale)%></td>
    <td class="tableLeft"><%=dfAmount.format(sumQuantity)%></td>
  </tr>
  <tr bgcolor="#ffffff">
    <td colspan="10"><hr/></td>
  </tr>
</table>
</body>
</html:html>
给你个例子,是html格式的,可以直接运行,你一下子就明白了,可以直接吧table中的内容导入到excel:<%@ page contentType="text/html; charset=GBK"%>
<input type="hidden" name="out_excel" onclick="AutomateExcel();" value="导出到excel" class="notPrint"> <title>浏览器表格导出到Excel</title>
<input type="button" name="out_word1" onclick="javascript:AutomateExcel() " value="导出到excel" class="notPrint">
<table id="data" width="200" border="1">
  <tr>
    <td>我是李春雷</td>
    <td>11</td>
  </tr>
  <tr>
    <td>22</td>
    <td>22</td>
  </tr>
  <tr>
    <td>33</td>
    <td>33</td>
  </tr>
  <tr>
    <td>44　</td>
    <td>44</td>
  </tr>
</table>
我是李春雷
<SCRIPT LANGUAGE="JavaScript">

</SCRIPT>
点击button后没有反应，提示有错误，我的页面是在“iframe”中的，这有关系吗？谢谢。
可以的，只要在HTML文件中加入<%@ page contentType="application/msexcel;charset=GBK"%>
意识是说用EXCEL程序打开！！！！？？？
我想要实现的的确是如“ lcllcl987”老兄的例子，点击bottun后输出excel文件。我用了“lcllcl987”的方法，但是没有成功。
把我的代码贴出来，请“lcllcl987”帮忙看看：
<%@ taglib uri="/WEB-INF/struts-tiles.tld" prefix="tiles" %>
<%@ taglib uri="/WEB-INF/struts-nested.tld" prefix="nested" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/struts-template.tld" prefix="template" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ page import="com.trademis.web.reportBean.ProductSaleReport,java.math.BigDecimal,java.lang.Double,java.text.DecimalFormat" %>
<%@ page contentType="text/html; charset=GBK"%>
<%int i=1;%>
<%
DecimalFormat dfAmount = new DecimalFormat("#.000");
    DecimalFormat dfMoney = new DecimalFormat("#.00");
double sumAmountInto =0;
double sumAmountSale =0;
        double sumAmountAllocateInto =0;
        double sumAmountAllocateSale =0;
        double sumQuantity =0;
%>
<html:html>
<head>
<title>
产品销售数量统计
</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../CSS/trade.CSS" rel="stylesheet" type="text/css"></head>
<body>
<input type="button" name="out_excel" onclick="AutomateExcel();" value="导出到excel" class="notPrint">
<table id="data" width="100%"  class="tablebg" align="center" cellpadding="3" cellspacing="1">
  <caption>产品销售数量统计</caption>
  <tr class="tabletitle">
    <td>序号</td>
    <td>产品</td>
    <td>累计收入</td>
    <td>销售数量</td>
    <td>调入</td>
    <td>调出</td>
    <td>实际库存</td>
  </tr>
  <logic:iterate name="LogList" id="log" scope="request" type="com.trademis.web.reportBean.ProductSaleReport">
  <%
double amountInto =Double.parseDouble(((ProductSaleReport)log).getAmountInto());
        double amountSale=Double.parseDouble(((ProductSaleReport)log).getAmountSale());
        double amountAllocateInto=Double.parseDouble(((ProductSaleReport)log).getAmountAllocateInto());
        double amountAllocateSale=Double.parseDouble(((ProductSaleReport)log).getAmountAllocateSale());
        double quantity=Double.parseDouble(((ProductSaleReport)log).getQuantity());%>
  <tr>
    <td class="tableCenter"><%=i++%></td>
    <td class="tableCenter"><bean:writeTrans dictionary="ProductInfo" name="log" property="productCode"/></td>
    <td class="tableLeft"><div align="right"><bean:write name="log" property="amountInto" formatKey="format.money"/></div></td>
    <td class="tableLeft"><div align="right"><bean:write name="log"   property="amountSale" formatKey="format.money"/></div></td>
    <td class="tableLeft"><div align="right"><bean:write name="log"   property="amountAllocateInto" formatKey="format.money"/></div></td>
    <td class="tableLeft"><div align="right"><bean:write name="log"   property="amountAllocateSale" formatKey="format.money"/></div></td>
    <td class="tableLeft"><div align="right"><bean:write name="log"   property="quantity" formatKey="format.money"/></div></td>
    <%
sumAmountInto +=amountInto;
sumAmountSale +=amountSale;
        sumAmountAllocateInto +=amountAllocateInto;
        sumAmountAllocateSale +=amountAllocateSale;
        sumQuantity +=quantity;
%>
  </tr>
  </logic:iterate>
  <tr>
    <td class="tableCenter"></td>
    <td class="tableCenter">合计</td>
    <td class="tableLeft"><%=dfAmount.format(sumAmountInto)%></td>
    <td class="tableLeft"><%=dfAmount.format(sumAmountSale)%></td>
    <td class="tableLeft"><%=dfAmount.format(sumAmountAllocateInto)%></td>
    <td class="tableLeft"><%=dfAmount.format(sumAmountAllocateSale)%></td>
    <td class="tableLeft"><%=dfAmount.format(sumQuantity)%></td>
  </tr>
  <tr bgcolor="#ffffff">
    <td colspan="10"><hr/></td>
  </tr>
</table>
</body>
</html:html>
<SCRIPT LANGUAGE="JavaScript">
function AutomateExcel()
{
// Start Excel and get Application object.
var oXL = new ActiveXObject("Excel.Application");
// Get a new workbook.
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var table = document.all.data;
var hang = table.rows.length;

var lie = table.rows(0).cells.length;

// Add table headers going cell by cell.
for (i=0;i<hang;i++)
{
for (j=0;j<lie;j++)
{
oSheet.Cells(i+1,j+1).Value = table.rows(i).cells(j).innerText;
}

}
oXL.Visible = true;
oXL.UserControl = true;
}
</SCRIPT>
去掉<tr bgcolor="#ffffff">
    <td colspan="10"><hr/></td>
  </tr>
试试！
上面lcllcl987的例子仅支持colspan＝1和rowspan＝1的情况。>1的话得再改改。
一点拙见！
我的例子可以成功啊!
你copy到你的html文件中试验一下,一点问题也没的
我验证了，是可以成功，但是浏览器会阻止你的javascript，客户使用了可能不方便。
非常感谢大家！
唯一有点遗憾的就如flyingis说的“浏览器会阻止你的javascript，客户使用了可能不方便。”
但先这样啦。