读书人

关于jsp页面导出excel的有关问题

发布时间: 2012-08-26 16:48:05 作者: rapoo

关于jsp页面导出excel的问题

使用jxl的话可以参考如下代码
在action中加入
response.setContentType("application/vnd.ms-excel;charset=GBK");
response.setHeader("Content-disposition", "attachment; filename=" + "test.xls");
OutputStream os = response.getOutputStream();
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
。。。。。
wwb.write();
wwb.close();
使用poi的话参考
response.setContentType("application/vnd.ms-excel;charset=GBK");
response.setHeader("Content-disposition", "attachment; filename=" + "test.xls");
OutputStream os = response.getOutputStream();
HSSFWorkbook workBook = new HSSFWorkbook();
workBook.write(os);
os.flush();
os.close();

读书人网 >JavaScript

热点推荐