`

jsp动态生成xls文件并下载

阅读更多
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="jxl.*" %>
<%@ page import="jxl.write.*" %>
<%
     response.reset();
     response.setContentType("application/x-msdownload");
	 response.setHeader("Content-Disposition",   "attachment;   filename="+new String("中文文件名测试.xls".getBytes(),"iso8859-1"));
     ServletOutputStream sos = response.getOutputStream();
     jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(sos);
     jxl.write.WritableSheet ws = wwb.createSheet("Test Sheet 1", 0);
//具体操作
//写入Exel工作表
     wwb.write();
//关闭Excel工作薄对象
     wwb.close();
 %>
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics