81,116
社区成员
发帖
与我相关
我的任务
分享各位兄弟帮忙，怎么样把JSP里面的所查询到的页面结果集保存到Execl里面？？？
我用JSP不是很长时间，现在要实现，把查询到的结果页面保存到EXEC里面，谁知道怎么做
最好有原代码，谢谢了！
最好有原代码，谢谢了！
...全文
请发表友善的回复…
发表回复
majy 2004-09-23
- 打赏
- 举报
把页面通过jxl直接输出成excel
sxl6159078 2004-09-23
- 打赏
- 举报
<HTML>
<HEAD>
<META http-equiv="Conent-Type" CONTENT="text/html;charset=gb2312">
<TITLE>Sample打印</TITLE>
</HEAD>
<%@ page contentType="text/html; charset=gb2312"%>
<SCRIPT>
var goXL = new ActiveXObject("Excel.Application");
var goWB = goXL.Workbooks.Open("D:\\tomcat\\webapps\\test\\Templete\\Sample.xlt");
var goSheet = goWB.ActiveSheet;
goXL.Visible = true;
goXL.run("sheet_active");
</SCRIPT>
<BODY>
<SCRIPT>
goSheet.Cells(5,1).value = "1月";
goSheet.Cells(5,2).value = "2月";
goSheet.Cells(5,3).value = "3月";
goSheet.Cells(5,4).value = "4月";
goSheet.Cells(5,5).value = "5月";
goSheet.Cells(5,6).value = "6月";
goSheet.Cells(5,7).value = "7月";
goSheet.Cells(5,8).value = "8月";
goSheet.Cells(5,9).value = "9月";
goSheet.Cells(5,10).value = "10月";
goSheet.Cells(5,11).value = "11月";
goSheet.Cells(5,12).value = "12月";
goSheet.Cells(1,1).value = "SAMPLE打印";
goXL.DisplayAlerts = false;
goXL.Visible = true;
</SCRIPT>
</body>
</html>
<SCRIPT>
window.close();
</SCRIPT>
<HEAD>
<META http-equiv="Conent-Type" CONTENT="text/html;charset=gb2312">
<TITLE>Sample打印</TITLE>
</HEAD>
<%@ page contentType="text/html; charset=gb2312"%>
<SCRIPT>
var goXL = new ActiveXObject("Excel.Application");
var goWB = goXL.Workbooks.Open("D:\\tomcat\\webapps\\test\\Templete\\Sample.xlt");
var goSheet = goWB.ActiveSheet;
goXL.Visible = true;
goXL.run("sheet_active");
</SCRIPT>
<BODY>
<SCRIPT>
goSheet.Cells(5,1).value = "1月";
goSheet.Cells(5,2).value = "2月";
goSheet.Cells(5,3).value = "3月";
goSheet.Cells(5,4).value = "4月";
goSheet.Cells(5,5).value = "5月";
goSheet.Cells(5,6).value = "6月";
goSheet.Cells(5,7).value = "7月";
goSheet.Cells(5,8).value = "8月";
goSheet.Cells(5,9).value = "9月";
goSheet.Cells(5,10).value = "10月";
goSheet.Cells(5,11).value = "11月";
goSheet.Cells(5,12).value = "12月";
goSheet.Cells(1,1).value = "SAMPLE打印";
goXL.DisplayAlerts = false;
goXL.Visible = true;
</SCRIPT>
</body>
</html>
<SCRIPT>
window.close();
</SCRIPT>
yanmount 2004-09-23
- 打赏
- 举报
请见：
http://groups.yahoo.com/group/JExcelApi/
“最好有原代码”，这个还是要有自学能力的，在这个行业不太可能
http://groups.yahoo.com/group/JExcelApi/
“最好有原代码”，这个还是要有自学能力的，在这个行业不太可能
