修复combo属性过多sheet出现的异常问题

RuoYi

2025-11-13 6aecd35a4ff01c2811e3bc9aaf55a8f566e2ca10

 ruoyi-common/ruoyi-common-core/src/main/java/com/ruoyi/common/core/utils/poi/ExcelUtil.java

@@ -73,6 +73,8 @@
{

    private static final Logger log = LoggerFactory.getLogger(ExcelUtil.class);



    public static final String SEPARATOR = ",";



    public static final String FORMULA_REGEX_STR = "=|-|\\+|@";



    public static final String[] FORMULA_STR = { "=", "-", "+", "@" };

@@ -156,11 +158,6 @@
     * 统计列表

     */

    private Map<Integer, Double> statistics = new HashMap<Integer, Double>();



    /**

     * 数字格式

     */

    private static final DecimalFormat DOUBLE_FORMAT = new DecimalFormat("######0.00");



    /**

     * 实体对象

@@ -724,6 +721,7 @@
        style = wb.createCellStyle();

        style.setAlignment(HorizontalAlignment.CENTER);

        style.setVerticalAlignment(VerticalAlignment.CENTER);

        style.setDataFormat(dataFormat.getFormat("######0.00"));

        Font totalFont = wb.createFont();

        totalFont.setFontName("Arial");

        totalFont.setFontHeightInPoints((short) 10);

@@ -1081,18 +1079,36 @@
    public void setXSSFValidationWithHidden(Sheet sheet, String[] textlist, String promptContent, int firstRow, int endRow, int firstCol, int endCol)

    {

        String hideSheetName = "combo_" + firstCol + "_" + endCol;

        Sheet hideSheet = wb.createSheet(hideSheetName); // 用于存储 下拉菜单数据

        for (int i = 0; i < textlist.length; i++)

        Sheet hideSheet = null;

        String hideSheetDataName = hideSheetName + "_data";

        Name name = wb.getName(hideSheetDataName);

        if (name != null)

        {

            hideSheet.createRow(i).createCell(0).setCellValue(textlist[i]);

            // 名称已存在，尝试从名称的引用中找到sheet名称

            String refersToFormula = name.getRefersToFormula();

            if (StringUtils.isNotEmpty(refersToFormula) && refersToFormula.contains("!"))

            {

                String sheetNameFromFormula = refersToFormula.substring(0, refersToFormula.indexOf("!"));

                hideSheet = wb.getSheet(sheetNameFromFormula);

            }

        }

        // 创建名称，可被其他单元格引用

        Name name = wb.createName();

        name.setNameName(hideSheetName + "_data");

        name.setRefersToFormula(hideSheetName + "!$A$1:$A$" + textlist.length);



        if (hideSheet == null)

        {

            hideSheet = wb.createSheet(hideSheetName); // 用于存储 下拉菜单数据

            for (int i = 0; i < textlist.length; i++)

            {

                hideSheet.createRow(i).createCell(0).setCellValue(textlist[i]);

            }

            // 创建名称，可被其他单元格引用

            name = wb.createName();

            name.setNameName(hideSheetDataName);

            name.setRefersToFormula(hideSheetName + "!$A$1:$A$" + textlist.length);

        }



        DataValidationHelper helper = sheet.getDataValidationHelper();

        // 加载下拉列表内容

        DataValidationConstraint constraint = helper.createFormulaListConstraint(hideSheetName + "_data");

        DataValidationConstraint constraint = helper.createFormulaListConstraint(hideSheetDataName);

        // 设置数据有效性加载在哪个单元格上,四个参数分别是：起始行、终止行、起始列、终止列

        CellRangeAddressList regions = new CellRangeAddressList(firstRow, endRow, firstCol, endCol);

        // 数据有效性对象

@@ -1130,7 +1146,7 @@
    public static String convertByExp(String propertyValue, String converterExp, String separator)

    {

        StringBuilder propertyString = new StringBuilder();

        String[] convertSource = converterExp.split(",");

        String[] convertSource = converterExp.split(SEPARATOR);

        for (String item : convertSource)

        {

            String[] itemArray = item.split("=");

@@ -1167,7 +1183,7 @@
    public static String reverseByExp(String propertyValue, String converterExp, String separator)

    {

        StringBuilder propertyString = new StringBuilder();

        String[] convertSource = converterExp.split(",");

        String[] convertSource = converterExp.split(SEPARATOR);

        for (String item : convertSource)

        {

            String[] itemArray = item.split("=");

@@ -1255,7 +1271,7 @@
            {

                cell = row.createCell(key);

                cell.setCellStyle(styles.get("total"));

                cell.setCellValue(DOUBLE_FORMAT.format(statistics.get(key)));

                cell.setCellValue(statistics.get(key));

            }

            statistics.clear();

        }

@@ -1449,7 +1465,8 @@
        {

            this.sheet = wb.createSheet();

            this.createTitle();

            wb.setSheetName(index, sheetName + index);

            int actualIndex = wb.getSheetIndex(this.sheet);

            wb.setSheetName(actualIndex, sheetName + index);

        }

    }