使用POI导出Excel文件并写多个Sheet页

import lombok.Data;

import java.util.List;

/**
 * @Description: Excel实体类
 * @Author 99231
 * @Date 2022/7/6
 * @Version V1.0
 **/
@Data
public class ExcelExp {
    //  sheet的名称
    private String fileName;
    //  sheet的标题
    private String[] handers;
    //  sheet里的数据集
    private List<String[]> dataset;

    public ExcelExp(String fileName, String[] handers, List<String[]> dataset) {
        this.fileName = fileName;
        this.handers = handers;
        this.dataset = dataset;
    }
}

import cn.hutool.core.collection.CollUtil;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.jeecg.common.exception.JeecgBootException;
import org.jeecg.common.util.DateUtils;

import java.io.File;
import java.io.FileOutputStream;
import java.lang.reflect.Field;
import java.util.*;

/**
 * @Description: Excel写出工具类
 * @Author 99231
 * @Date 2022/7/5
 * @Version V1.0
 **/
@Slf4j
public class ExcelExportUtils {

    public static void exportExcel(String upload, String fileName, List<ExcelExp> mysheets) {
        // 创建工作薄
        HSSFWorkbook wb = new HSSFWorkbook();
        List<ExcelExp> sheets = mysheets;
        // 数据样式
        HSSFCellStyle style = wb.createCellStyle();
        // 数据垂直
        style.setVerticalAlignment(VerticalAlignment.CENTER);
        // 数据水平
        style.setAlignment(HorizontalAlignment.CENTER);
        // 数据字体样式
        HSSFFont fontStyle = wb.createFont();
        fontStyle.setFontName("微软雅黑");
        fontStyle.setFontHeightInPoints((short) 10);
        style.setFont(fontStyle);
        // 数据自动换行
        style.setWrapText(true);
        for (ExcelExp excel : sheets) {
            // 获取该Sheet的名称
            HSSFSheet sheet = wb.createSheet(excel.getFileName());
            // 标题单元格合并
            sheet.addMergedRegionUnsafe(new CellRangeAddress(0, 0, 0, excel.getHanders().length - 1));
            Row rowTitle = sheet.createRow(0);
            Cell cellOne = rowTitle.createCell(0);
            // 标题单元格值
            cellOne.setCellValue(excel.getFileName() + "-" + DateUtils.getDate("yyyyMMdd"));
            // 标题风格
            HSSFCellStyle cellTitleStyle = wb.createCellStyle();
            cellTitleStyle.setAlignment(HorizontalAlignment.CENTER);
            cellTitleStyle.setVerticalAlignment(VerticalAlignment.CENTER);
            // 字体
            HSSFFont titleFont = wb.createFont();
            titleFont.setFontName("黑体");
            titleFont.setFontHeightInPoints((short) 12);
            cellTitleStyle.setFont(titleFont);
            cellOne.setCellStyle(cellTitleStyle);

            // 获取sheet的标题名
            String[] handers = excel.getHanders();
            // 第一个sheet的第一行位标题
            HSSFRow rowFirst = sheet.createRow(1);
            // 写标题
            for (int i = 0; i < handers.length; i++) {
                // 获取第一行的每个单元格
                HSSFCell cell = rowFirst.createCell(i);
                // 写数据
                cell.setCellValue(handers[i]);
                // 加样式
                cell.setCellStyle(cellTitleStyle);
                // 设置每列的列宽
                sheet.setColumnWidth(i, 6000);
                sheet.setDefaultRowHeight((short) 400);
            }
            // 写数据集
            List<String[]> dataset = excel.getDataset();
            for (int i = 0; i < dataset.size(); i++) {
                // 获取该对象
                String[] data = dataset.get(i);
                // 创建数据行
                HSSFRow row = sheet.createRow(i + 2);
                for (int j = 0; j < data.length; j++) {
                    // 判断数据中是否包含日期
                    // o.getCumulativeUnitDividendAssets().matches("[\u4e00-\u9fa5]+")
                    if (data[0].matches("[\u4e00-\u9fa5]+")) {
                        // 获取第一行的每个单元格
                        HSSFCell cellDate = row.createCell(j);
                        // 写数据
                        cellDate.setCellValue(data[j]);
                        // 加样式
                        cellDate.setCellStyle(cellTitleStyle);
                        // 设置每列的列宽
                        sheet.setColumnWidth(j, 6000);
                        sheet.setDefaultRowHeight((short) 400);
                    } else {
                        // 设置对应的值
                        HSSFCell cell = row.createCell(j);
                        cell.setCellValue(data[j]);
                        cell.setCellStyle(style);
                    }
                }
            }
        }
        // 创建写出流
        try {
            FileOutputStream output = new FileOutputStream(new File(upload + fileName));
            wb.write(output);
            output.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
   }