本文基于 HSSFWorkbook 实现自定义样式及多个sheet实现导出Excel
代码实现:
public void testExport(HttpServletResponse response) {
try {
HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
for (int i = 0; i < 5; i++) {
HSSFSheet sheet = hssfWorkbook.createSheet();
hssfWorkbook.setSheetName(i, "sheet" + i);
sheet.setDefaultColumnWidth(17); // 设置单元格的宽度
HSSFFont headfont = hssfWorkbook.createFont(); // 为首行设置字体
headfont.setFontName("宋体"); // 字体类型
headfont.setFontHeightInPoints((short) 12); // 字体大小
HSSFCellStyle headStyle = hssfWorkbook.createCellStyle(); // 创建单元格,并设置值表头
headStyle.setAlignment(HorizontalAlignment.CENTER);
headStyle.setFont(headfont); // 应用字体
String[] headContent0 = {"序号", "名称", "时间"};
HSSFRow titleRow = sheet.