jxls根据模板导出excel

最新推荐文章于 2023-09-19 15:56:41 发布

java_陈序猿

最新推荐文章于 2023-09-19 15:56:41 发布

阅读量768

点赞数

CC 4.0 BY-SA版权

分类专栏：工作中的笔记心得

本文链接：https://blog.youkuaiyun.com/maple980326/article/details/73913508

工作中的笔记心得专栏收录该内容

27 篇文章

订阅专栏

本文介绍了一个Java程序示例，该程序用于从数据库获取数据并将其导出为Excel文件。通过使用模板文件和XLSTransformer工具类，可以方便地实现数据到Excel表格的转换。文章提供了完整的代码实现及必要的资源链接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public class ExportExcel{
HttpServletRequest request;
HttpServletResponse response;
List saff;
String fileName;
public ExportExcel(HttpServletRequest request, HttpServletResponse response, List saff, String fileName ){
this.request=request;
this.response=response;
this.saff=saff;
this.fileName=fileName;
}
public void exportProject(String sourceName)throws Exception{
Map<String,Object> map=new HashMap<>();
map.put("fileName",fileName);
map.put("testforms",saff);
//获得模板路径
String path=request.getServletContext().getRealPath("excel_export");
String wjpath=path+ File.separator+sourceName;
//准备输出流
OutputStream os=null;
try {
//设置响应头
response.setContentType("application/x-excel");
//response.setHeader("Content-Disposition", "attachment;filename=studentInfo.xls");
response.setHeader("Content-Disposition", "attachment;filename="+new String((fileName+".xls").getBytes(),"iso8859-1"));
response.setContentType("application/ms-excel");
os = response.getOutputStream();
XLSTransformer transformer = new XLSTransformer();
try {
//获得模板的输入流
InputStream in = new BufferedInputStream(new FileInputStream(wjpath));
//将beans通过模板输入流写到workbook中
Workbook workbook = transformer.transformXLS(in, map);
//将workbook中的内容用输出流写出去
workbook.write(os);
os.flush();

}catch (Exception e) {
e.printStackTrace();
throw new RuntimeException();
}
} catch (Exception e) {
e.printStackTrace();
}
}

}

demo下载地址 http://download.youkuaiyun.com/download/maple980326/9959219

相关博客地址： http://blog.youkuaiyun.com/yuliqi0429/article/details/41907711