java,jsp,javascript中如何实现将统计表格保存成excel文件

java,jsp,javascript中如何实现将统计表格保存成excel文件？ --------------------------------------------------------------- < SCRIPT LANGUAGE="JavaScript" > 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< tblout.rows.length;i++) for(j=0;j< 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; } < /SCRIPT > //这个问题其实你搜一下就有了 --------------------------------------------------------------- 首先你的页面上要有一个按钮：save 这个按钮先做查询数据库，然后action转到保存excell的页面，即我给你的这些代码，由于我的是用这个页面是隐藏的，点击save时有跳出界面问你是打开还是保存，xxxxxxxxxxxxxx是你调用数据库的记录， < %@ page contentType="text/html;charset=gb2312" % > < %@ page import="java.lang.*"% > < % try{ response.setContentType("Application/msexcel"); response.setHeader("Content-Disposition", "attachment;filename=trainlist.xls"); StringBuffer cont=new StringBuffer(""); % > < HTML > < HEAD > < META http-equiv="Content-Style-Type" content="text/css" > < /HEAD > < BODY > < br >< br >< br > < % int status = khViewBean.getStatus(); if (status == 0){ int rscount = khViewBean.getRSCount(); % > < % cont.append("< html >< head >< META content=′text/html; charset=gb2312′ http-equiv=Content-Type >< /head >< body > "); cont.append("< h1 > SOP??μμ2é?ˉ?á1?< /h1 >"); cont.append("< table width=′100%′ border=′1′ > "); cont.append("< tr > "); cont.append("< td height=′19′ >???to? < /td > "); cont.append("< td height=′19′ >???t?? < /td > "); cont.append("< td height=′19′ >2??? < /td > "); cont.append("< td height=′19′ >éúD§ê±?? < /td > "); cont.append("< /tr > "); cont.append("< tr > "); cont.append("< td >"+xxxxxxxxxxxxxxxxxxxxxxxx +" < /td > "); cont.append("< td >"+xxxxxxxxxxxxxxxxxxxxxxxx +" < /td > "); cont.append("< td >"+xxxxxxxxxxxxxxxxxxxxxxxx +" < /td > "); cont.append("< td >"+xxxxxxxxxxxxxxxxxxxxxxxx +" < /td > "); cont.append("< /tr > "); cont.append("< tr > "); cont.append("< td >"+xxxxxxxxxxxxxxxxxxxxxxxx +" < /td > "); cont.append("< td >"+xxxxxxxxxxxxxxxxxxxxxxxx +" < /td > "); cont.append("< td >"+xxxxxxxxxxxxxxxxxxxxxxxx +" < /td > "); cont.append("< td >"+xxxxxxxxxxxxxxxxxxxxxxxx +" < /td > "); } cont.append("< /table > "); cont.append("< /body >< /html > "); response.getWriter().println(cont.toString()); response.getWriter().close(); % > < % } else if (status > 0) { % > < hr color="#6699CC" > < span class="text" >< font color="blue" size="16" >< center >< P >?Têy?Y < /P >< /center >< /font >< /span > < % } else if (status < 0) { % > < hr color="#6699CC" > < span class="text" >< font color="red" size="16" >< center >< P >?￠éú′í?ó < /P >< /center >< /font >< /span > < % } % > < hr color="#6699CC" > < % } catch (Exception e){ out.println(e.toString()); } % > < /BODY > < /HTML >