execl导入导出

最新推荐文章于 2022-11-28 12:32:49 发布

weixin_30807779

最新推荐文章于 2022-11-28 12:32:49 发布

阅读量59

点赞数

原文链接：http://www.cnblogs.com/kingxing/p/6423423.html

版权

1.导出：

response.setContentType("application/vnd.ms-excel; charset=utf-8");
response.setHeader("Content-Disposition","attachment;filename=" + new String(execlName.getBytes("gb2312"), "ISO8859-1"));
response.setCharacterEncoding("utf-8");
OutputStream os=response.getOutputStream();
//获得Execl表格
HSSFWorkbook wb = doExport(datas,titles,sheetName);
//写入流
wb.write(os);
os.flush();
//关闭流
os.close();
String path = "C:/Users/chencq3/Desktop/billList.xls";
FileOutputStream fileOut = new FileOutputStream(path);   
wb.write(fileOut);   
fileOut.close();