Java,jsp,javascript中如何实现将统计表格保存成Excel文件？
---------------------------------------------------------------
%26amp;lt SCRIPT LANGUAGE="JavaScript" %26amp;gt
function AutomateExcel()
{
var i,j;
// Start Excel and get Application object.
var oXL = new ActiveXObject("Excel.Application");

oXL.Visible = true;

// Get a new workbook.
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;

// Add table headers going cell by cell.
// tblout表的ID
for(i=0;i%26amp;lt tblout.rows.length;i++)
for(j=0;j%26amp;lt tblout.rows(i).cells.length;j++)
oSheet.Cells(i+1, j+1).Value = tblout.rows(i).cells(j).innerText

oXL.Visible = true;
oXL.UserControl = true;
}
%26amp;lt /SCRIPT %26amp;gt
//这个问题其实你搜一下就有了

---------------------------------------------------------------

首先你的页面上要有一个按钮：save
这个按钮先做查询数据库，然后action转到保存excell的页面，即我给你的这些代码，由于我的是用这个页面是隐藏的，点击save时有跳出界面问你是打开还是保存，xxxxxxxxxxxxxx是你调用数据库的记录，
%26amp;lt %@ page contentType="text/Html;charset=gb2312" % %26amp;gt
%26amp;lt %@ page import="java.lang.*"% %26amp;gt
%26amp;lt %
try{
response.setContentType("Application/msexcel");
response.setHeader("Content-Disposition", "attachment;filename=trainlist.xls");
StringBuffer cont=new StringBuffer("");
% %26amp;gt
%26amp;lt HTML %26amp;gt
%26amp;lt HEAD %26amp;gt
%26amp;lt META http-equiv="Content-Style-Type" content="text/Css" %26amp;gt
%26amp;lt /HEAD %26amp;gt
%26amp;lt BODY %26amp;gt
%26amp;lt br %26amp;gt%26amp;lt br %26amp;gt%26amp;lt br %26amp;gt
%26amp;lt %
int status = khViewBean.getStatus();
if (status == 0){
int rscount = khViewBean.getRSCount();
% %26amp;gt
%26amp;lt %
cont.append("%26amp;lt html %26amp;gt%26amp;lt head %26amp;gt%26amp;lt META content=′text/html; charset=gb2312′ http-equiv=Content-Type %26amp;gt%26amp;lt /head %26amp;gt%26amp;lt body %26amp;gt ");
cont.append("%26amp;lt h1 %26amp;gt SOP??μμ2é?ˉ?á1?%26amp;lt /h1 %26amp;gt");
cont.append("%26amp;lt table width=′100%′ border=′1′ %26amp;gt ");
cont.append("%26amp;lt tr %26amp;gt ");
cont.append("%26amp;lt td height=′19′ %26amp;gt???to? %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt td height=′19′ %26amp;gt???t?? %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt td height=′19′ %26amp;gt2??? %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt td height=′19′ %26amp;gtéúD§ê±?? %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt /tr %26amp;gt ");
cont.append("%26amp;lt tr %26amp;gt ");
cont.append("%26amp;lt td %26amp;gt"+xxxxxxxxxxxxxxxxxxxxxxxx +" %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt td %26amp;gt"+xxxxxxxxxxxxxxxxxxxxxxxx +" %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt td %26amp;gt"+xxxxxxxxxxxxxxxxxxxxxxxx +" %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt td %26amp;gt"+xxxxxxxxxxxxxxxxxxxxxxxx +" %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt /tr %26amp;gt ");
cont.append("%26amp;lt tr %26amp;gt ");
cont.append("%26amp;lt td %26amp;gt"+xxxxxxxxxxxxxxxxxxxxxxxx +" %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt td %26amp;gt"+xxxxxxxxxxxxxxxxxxxxxxxx +" %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt td %26amp;gt"+xxxxxxxxxxxxxxxxxxxxxxxx +" %26amp;lt /td %26amp;gt ");
cont.append("%26amp;lt td %26amp;gt"+xxxxxxxxxxxxxxxxxxxxxxxx +" %26amp;lt /td %26amp;gt ");
}
cont.append("%26amp;lt /table %26amp;gt ");
cont.append("%26amp;lt /body %26amp;gt%26amp;lt /html %26amp;gt ");
response.getWriter().println(cont.toString());
response.getWriter().close();
% %26amp;gt
%26amp;lt %
}
else if (status %26amp;gt 0) {
% %26amp;gt
%26amp;lt hr color="#6699CC" %26amp;gt
%26amp;lt span class="text" %26amp;gt%26amp;lt font color="blue" size="16" %26amp;gt%26amp;lt center %26amp;gt%26amp;lt P %26amp;gt?Têy?Y %26amp;lt /P %26amp;gt%26amp;lt /center %26amp;gt%26amp;lt /font %26amp;gt%26amp;lt /span %26amp;gt
%26amp;lt %
}
else if (status %26amp;lt 0) {
% %26amp;gt
%26amp;lt hr color="#6699CC" %26amp;gt
%26amp;lt span class="text" %26amp;gt%26amp;lt font color="red" size="16" %26amp;gt%26amp;lt center %26amp;gt%26amp;lt P %26amp;gt?￠éú′í?ó %26amp;lt /P %26amp;gt%26amp;lt /center %26amp;gt%26amp;lt /font %26amp;gt%26amp;lt /span %26amp;gt
%26amp;lt %
}
% %26amp;gt
%26amp;lt hr color="#6699CC" %26amp;gt
%26amp;lt %
}
catch (Exception e){
out.println(e.toString());
}
% %26amp;gt
%26amp;lt /BODY %26amp;gt
%26amp;lt /HTML %26amp;gt