Java实现Excel导入和导出,看这一篇就够了(珍藏版2.0)
天空Duang:
[code=java]
private static void export(HttpServletResponse response, Workbook workbook, String fileName) {
try {
if (isEmpty(fileName)) {
fileName = System.currentTimeMillis() + "";
}
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding(StandardCharsets.UTF_8.displayName());
/* String name = new String(fileName.getBytes(StandardCharsets.UTF_8), StandardCharsets.ISO_8859_1) + ExcelType.XLSX.val;
response.addHeader("Content-Disposition", "attachment;filename=" + name);*/
// 处理中文文件名
String encodedFileName = URLEncoder.encode(fileName, "UTF-8");
response.addHeader("Content-Disposition", "attachment;filename=" + encodedFileName + ".xlsx");
ServletOutputStream out = response.getOutputStream();
workbook.write(out);
out.flush();
out.close();
}
[/code] 把Uitls这样改就是中文的了,xlsx文件
|