hutool工具的BigExcelWriter导出数据设置excel表的行高不生效
private void getExcel(List<Map<String, Object>> list) {
RequestAttributes requestAttributes = RequestContextHolder.getRequestAttributes();
HttpServletResponse response = ((ServletRequestAttributes) requestAttributes).getResponse();
//excel大数据生成
BigExcelWriter writer=new BigExcelWriter();
Sheet sheet = writer.getSheet();
sheet.setDefaultRowHeight((short) 4000);
writer.write(list);
response.reset();
response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(tableName+".xlsx", "UTF-8"));
response.setContentType("multipart/form-data");
try {
writer.flush(response.getOutputStream());
} catch (IOException e) {
e.printStackTrace();
} finally {
if (writer!=null){
//关闭writer 释放内存
writer.close();
}
}
}
效果: