海恒-鸿瑞堂
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
Pu Zhibing
2025-04-01 8444084e6aa11efa23287e7f82474ac22378a5c4 
 ruoyi-common/ruoyi-common-core/src/main/java/com/ruoyi/common/core/utils/poi/ExcelUtil.java


@@ -1,56 +1,5 @@


package com.ruoyi.common.core.utils.poi;




import java.io.IOException;


import java.io.InputStream;


import java.lang.reflect.Field;


import java.lang.reflect.Method;


import java.lang.reflect.ParameterizedType;


import java.math.BigDecimal;


import java.text.DecimalFormat;


import java.time.LocalDate;


import java.time.LocalDateTime;


import java.util.ArrayList;


import java.util.Arrays;


import java.util.Collection;


import java.util.Comparator;


import java.util.Date;


import java.util.HashMap;


import java.util.List;


import java.util.Map;


import java.util.Set;


import java.util.stream.Collectors;


import javax.servlet.http.HttpServletResponse;


import org.apache.commons.lang3.ArrayUtils;


import org.apache.commons.lang3.RegExUtils;


import org.apache.commons.lang3.reflect.FieldUtils;


import org.apache.poi.ss.usermodel.BorderStyle;


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.ClientAnchor;


import org.apache.poi.ss.usermodel.DataValidation;


import org.apache.poi.ss.usermodel.DataValidationConstraint;


import org.apache.poi.ss.usermodel.DataValidationHelper;


import org.apache.poi.ss.usermodel.DateUtil;


import org.apache.poi.ss.usermodel.Drawing;


import org.apache.poi.ss.usermodel.FillPatternType;


import org.apache.poi.ss.usermodel.Font;


import org.apache.poi.ss.usermodel.HorizontalAlignment;


import org.apache.poi.ss.usermodel.IndexedColors;


import org.apache.poi.ss.usermodel.Name;


import org.apache.poi.ss.usermodel.Row;


import org.apache.poi.ss.usermodel.Sheet;


import org.apache.poi.ss.usermodel.VerticalAlignment;


import org.apache.poi.ss.usermodel.Workbook;


import org.apache.poi.ss.usermodel.WorkbookFactory;


import org.apache.poi.ss.util.CellRangeAddress;


import org.apache.poi.ss.util.CellRangeAddressList;


import org.apache.poi.util.IOUtils;


import org.apache.poi.xssf.streaming.SXSSFWorkbook;


import org.apache.poi.xssf.usermodel.XSSFClientAnchor;


import org.apache.poi.xssf.usermodel.XSSFDataValidation;


import org.slf4j.Logger;


import org.slf4j.LoggerFactory;


import com.ruoyi.common.core.annotation.Excel;


import com.ruoyi.common.core.annotation.Excel.ColumnType;


import com.ruoyi.common.core.annotation.Excel.Type;


@@ -61,6 +10,31 @@


import com.ruoyi.common.core.utils.file.FileTypeUtils;


import com.ruoyi.common.core.utils.file.ImageUtils;


import com.ruoyi.common.core.utils.reflect.ReflectUtils;


import org.apache.commons.lang3.ArrayUtils;


import org.apache.commons.lang3.RegExUtils;


import org.apache.commons.lang3.reflect.FieldUtils;


import org.apache.poi.ss.usermodel.*;


import org.apache.poi.ss.util.CellRangeAddress;


import org.apache.poi.ss.util.CellRangeAddressList;


import org.apache.poi.util.IOUtils;


import org.apache.poi.xssf.streaming.SXSSFWorkbook;


import org.apache.poi.xssf.usermodel.XSSFClientAnchor;


import org.apache.poi.xssf.usermodel.XSSFDataValidation;


import org.slf4j.Logger;


import org.slf4j.LoggerFactory;




import javax.servlet.http.HttpServletResponse;


import java.io.IOException;


import java.io.InputStream;


import java.lang.reflect.Field;


import java.lang.reflect.Method;


import java.lang.reflect.ParameterizedType;


import java.math.BigDecimal;


import java.text.DecimalFormat;


import java.time.LocalDate;


import java.time.LocalDateTime;


import java.util.*;


import java.util.stream.Collectors;




/**


 * Excel相关处理


@@ -456,7 +430,7 @@


    public void exportExcel(HttpServletResponse response, List<T> list, String sheetName, String title)


    {


        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");


        response.setCharacterEncoding("utf-8");


        response.setCharacterEncoding("UTF-8");


        this.init(list, sheetName, title, Type.EXPORT);


        exportExcel(response);


    }


@@ -482,7 +456,7 @@


    public void importTemplateExcel(HttpServletResponse response, String sheetName, String title)


    {


        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");


        response.setCharacterEncoding("utf-8");


        response.setCharacterEncoding("UTF-8");


        this.init(null, sheetName, title, Type.IMPORT);


        exportExcel(response);


    }