代码如下:
import cn.hutool.core.io.IoUtil;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import org.apache.poi.ss.formula.functions.T;
import java.io.IOException;
import java.text.SimpleDateFormat;
ArrayList<Map<String, Object>> rows = new ArrayList<>();
list.forEach(expoVo -> {
Map<String, Object> row1 = new LinkedHashMap<>();
row1.put("1公司", expoVo.getRegionalName());
row1.put("2公司", expoVo.getUrbanName());
row1.put("3名称", expoVo.getProjectName());
row1.put("名称", expoVo.getServiceName());
row1.put("专业", expoVo.getProfessionName());
row1.put("创建时间", expoVo.getCreateTime());
rows.add(row1);
});
ExcelWriter bigWriter = ExcelUtil.getBigWriter();
ServletOutputStream out = null;
try {
bigWriter.write(rows);
bigWriter.setColumnWidth(-1, 22);
response.setContentType("application/vnd.ms-excel;charset=utf-8");
SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String fileName = "文件导出" + f.format(new Date());
response.setHeader("Content-Disposition", "attachment;filename=" + new String((fileName + ".xlsx").getBytes(), "iso-8859-1"));
out = response.getOutputStream();
bigWriter.flush(out, true);
} catch (IOException e) {
e.printStackTrace();
} finally {
bigWriter.close();
IoUtil.close(out);
}