工具类
/***
* 自定义使用文件流导出Excel文件
* @param response 响应
* @param workbook 对象
*/
public static void excelExport(HttpServletResponse response, Workbook workbook) throws IOException {
OutputStream outputStream = null;
try {
// 输出Excel文件
outputStream = response.getOutputStream();
// 下面几行是为了解决文件名乱码的问题
response.setHeader("Content-Disposition", "attachment;filename=" + new String((generateRandomFileName()).getBytes(), "UTF-8") + ".xlsx");
response.setContentType("application/vnd.ms-excel;charset=UTF-8");
//关闭缓存
response.setHeader("Pragma", "no-cache");
//关闭缓存
response.setHeader("Cache-Control", "no-cache");
//让浏览器不要缓存页面,可以利用Expires实体报关域,设置为0
response.setDateHeader("Expi