Java开发网 - JSP中倒出Excel？

Topic: JSP中倒出Excel？

1.JSP中倒出Excel？	Copy to clipboard
Posted by: lwwbill Posted on: 2003-09-22 10:55 如何在JSP中倒出Excel，又怎么样更改Excel的表头字段名？谢谢

2.Re:JSP中倒出Excel？ [Re: lwwbill]	Copy to clipboard
Posted by: menzy Posted on: 2003-09-23 08:02 apache有一个项目POI可以 opensource也有，不过我潜意识里觉得应当用apache的

3.Re:JSP中倒出Excel？ [Re: lwwbill]

Copy to clipboard

Posted by: archonLing
Posted on: 2003-09-23 10:09

lwwbill wrote:
如何在JSP中倒出Excel，又怎么样更改Excel的表头字段名？谢谢

There is open source product call ExcelRead. It is pretty good for both reading & writing excel output.

You could also try to trick the brower to load the data in excel by setting page mime type to excel on top of your page. Ex:

response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment;filename=test.xls");

It is quick & dirty want to do export to excel. LOL...

4.Re:JSP中倒出Excel？ [Re: archonLing]

Copy to clipboard

Posted by: palor
Posted on: 2003-12-17 22:40

archonLing wrote:

You could also try to trick the brower to load the data in excel by setting page mime type to excel on top of your page. Ex:

response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment;filename=test.xls");

Of course! But it is carried out on the condition that the cliet has install MS-Excel, otherwise the clieter should point out the program . Smile

5.Re:JSP中倒出Excel？ [Re: lwwbill]	Copy to clipboard
Posted by: javaxml1 Posted on: 2003-12-18 10:31 请参阅 http://www.huangpuzhuang.com/article/java_excel.rar