poi导出到本地选择本地路径保存到本地

最新推荐文章于 2023-10-23 16:42:28 发布

原创最新推荐文章于 2023-10-23 16:42:28 发布 · 126 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍如何利用poi库将数据导出为excel文件，并将其保存至本地计算机，涉及字符编码设置、文件名编码、样式设置及数据填充等关键步骤。

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

//poi导出excel 保存到本地

public void exportExcel(HttpServletRequest req, HttpServletResponse resp) throws IOException{

HSSFWorkbook wb = new HSSFWorkbook();
req.setCharacterEncoding("UTF-8");
resp.setCharacterEncoding("UTF-8");
resp.setContentType("application/x-download");

String filedisplay = "未匹配的产品清单.xls";
filedisplay = URLEncoder.encode(filedisplay, "UTF-8");
resp.addHeader("Content-Disposition", "attachment;filename="+ filedisplay);
HSSFSheet sheet = wb.createSheet("未匹配产品");
sheet.setColumnWidth(0, 50*160);
HSSFFont font = wb.createFont();
font.setFontName("宋体");
font.setFontHeightInPoints((short) 16);

HSSFRow row = sheet.createRow((int) 0);

HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);

HSSFCell cell = row.createCell(0);
cell.setCellValue("产品名称");

Map<String, Object> params = new HashMap<String, Object>();
params.put("userId", this.getMember().getId());
params.put("matchabled", 0);
List<Match> matchs = this.getBeanManager().listBean(Match.class, params);

for (int i = 0; i < matchs.size(); i++) {
row = sheet.createRow((int) i + 1);
Match match = (Match) matchs.get(i);
row.createCell(0).setCellValue(match.getName());
}
try {
OutputStream out = resp.getOutputStream();
wb.write(out);
out.close();
}
catch (Exception e) {
e.printStackTrace();
}
}