JSP生成EXCEL的问题!

Question

<%@ page import=" org.apache.poi.hssf.usermodel.HSSFCell"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCellStyle"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFDataFormat"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFFont"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@ page import="org.apache.poi.hssf.util.HSSFColor"%>
<%@ page import="java.io.*,java.util.*"%>
<%
response.setContentType("Application/msexcel");
response.setHeader("Content-disposition","attachment; filename=workbook.xls" );
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheet1");
HSSFRow row     = sheet.createRow((short)0);
HSSFCell cell0   = row.createCell((short)0);
cell0.setEncoding(HSSFCell.ENCODING_UTF_16);
cell0.setCellValue("一个字符串值");
FileOutputStream fileOut = new FileOutputStream("sample.xls");
wb.write(fileOut);
fileOut.close();
OutputStream outsys = response.getOutputStream();
wb.write(outsys);
outsys.close();
%>
上面是写在JSP中的一段代码,用文件输出的EXCEL文件是正常的,但是直接从JSP输出的EXCEL在TOMCAT中是正常的,在RESIN中却不正常,找了半天也没发现问题,请大家帮忙看下吧!

Answer 1

不正常是怎么样子呢？这段代码对Tomcat没有依赖性啊

Answer 2

是不是java execl类的jar文件没有拷贝到resin的lib路径中？

Answer 3

现在就是两种服务器中用文件输出的sample.xls文件是正常的,
但是直接从JSP输出的workbook.xls在TOMCAT中是正常的,在RESIN中却是乱码,
不知这和response.setHeader("Content-disposition","attachment; filename=workbook.xls" );有什么关系,
TOMCAT为5.0,RESIN为2.1

Answer 4

<%@ page import=" org.apache.poi.hssf.usermodel.HSSFCell"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCellStyle"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFDataFormat"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFFont"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@ page import="org.apache.poi.hssf.util.HSSFColor"%>是java包吗?  楼主能发给我吗[email protected]

Answer 5

呵呵，是JAKATA项目的子项目POI，到WWW.APACHE.ORG上就可以下载

Answer 6

看来和语言相关，看看resin的缺省语言另外操作系统的字符集也相关，什么操作系统？

Answer 7

操作系统是2000 SERVER,现在的问题是通过文件流都可以正常输出,但是通过JSP的RESPONSE输出就只有TOMCAT正常了,错误日志,读写日志都没有问题,这下傻了!