poi、easyexcel、poi-tl升级 ，合并空调中的报表、数据源模块

许鹏程

2023-06-29 daea7f5c66346b74e9c1ae6b56e01540aee01e60

poi、easyexcel、poi-tl升级 ，合并空调中的报表、数据源模块

 src/main/java/com/product/module/data/service/SystemDataExportService.java

@@ -26,6 +26,7 @@
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.net.URLEncoder;
import java.util.*;

/**
@@ -291,6 +292,10 @@

        response.setContentType("multipart/form-data");
        response.setCharacterEncoding("utf-8");
        //允许访问header中的自定义参数
        response.setHeader("Access-Control-Expose-Headers", "Content-Disposition");
        //设置文件名
        response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode(sheetName + System.currentTimeMillis() + ".xlsx", "UTF-8"));
        // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
        // 这里需要设置不关闭流
        try (ServletOutputStream outputStream = response.getOutputStream();) {

 src/main/java/com/product/module/data/utli/Custemhandler.java

@@ -1,11 +1,12 @@
package com.product.module.data.utli;

import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.CellData;
import com.alibaba.excel.metadata.Head;
import com.alibaba.excel.util.CollectionUtils;
import com.alibaba.excel.metadata.data.CellData;
import com.alibaba.excel.metadata.data.WriteCellData;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.style.column.AbstractColumnWidthStyleStrategy;
import org.apache.commons.collections4.CollectionUtils;
import org.apache.poi.ss.usermodel.Cell;

import java.util.HashMap;
@@ -18,7 +19,7 @@
    private Map<Integer, Map<Integer, Integer>> cache = new HashMap<Integer, Map<Integer, Integer>>(8);

    @Override
    protected void setColumnWidth(WriteSheetHolder writeSheetHolder, List<CellData> cellDataList, Cell cell, Head head,
    protected void setColumnWidth(WriteSheetHolder writeSheetHolder, List<WriteCellData<?>> cellDataList, Cell cell, Head head,
                                  Integer relativeRowIndex, Boolean isHead) {
        boolean needSetWidth = isHead || !CollectionUtils.isEmpty(cellDataList);
        if (!needSetWidth) {
@@ -43,7 +44,7 @@
        }
    }

    private Integer dataLength(List<CellData> cellDataList, Cell cell, Boolean isHead) {
    private Integer dataLength(List<WriteCellData<?>> cellDataList, Cell cell, Boolean isHead) {
        if (isHead) {
            return cell.getStringCellValue().getBytes().length;
        }