大数据最新性能爆炸！SXSSFWorkbook原文件上追加写入&amp；分页导出(2)

org.apache.commons

commons-compress

${commons.compress.version}

工具类

import dbox.tbox.lang.DateUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.lang.reflect.Field;
import java.lang.reflect.Modifier;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.stream.Stream;

/**

• @Author ping

• @Date 2023/12/4 17:04

• excel工具类 用于service服务的导出，不使用export模式
  */
  public class ExcelUtil {
  // 读取 Excel 文件并将其映射为具体的 Java 对象
  public static List readExcel(String filePath, Class clazz) throws Exception {
  List objects = new ArrayList<>();
  try (FileInputStream fis = new FileInputStream(filePath);
  Workbook workbook = new XSSFWorkbook(fis)) {

       Sheet sheet = workbook.getSheetAt(0); // 选择工作表
  
       for (int i = 1; i <= sheet.getLastRowNum(); i++) {
           Row row = sheet.getRow(i);
           T obj = clazz.getDeclaredConstructor().newInstance();
  
           for (int j = 0; j < row.getLastCellNum(); j++) {
               Cell cell = row.getCell(j);
               String fieldName = sheet.getRow(0).getCell(j).getStringCellValue();
               Field field = clazz.getDeclaredField(fieldName);
               field.setAccessible(true);
               //跳过静态属性
               if (Modifier.isStatic(field.getModifiers())){
                   continue;
               }
               //单元格为空的情况
               if (cell == null){
                   continue;
               }
               if (cell.getCellType() == CellType.NUMERIC) {
                   double numericValue = cell