Attempting to write a row[0] in the range [0,1341] that is already written to disk

今天生产服务下载excel模板的时候突然爆出来这个错：Attempting to write a row[0] in the range [0,1341] that is already written to disk

之前一直好好地，后来百度才知道，原来是因为在写入excel封装下拉框的时候，下拉框数据太大，导致的磁盘合并出现问题。
解决方法：每一个字典项创建一个sheet页（需要设置sheet页隐藏，否则字典项sheet页会出现）
原代码如下：

public void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
        // 需要设置下拉框的sheet页
        Sheet curSheet = writeSheetHolder.getSheet();
        DataValidationHelper helper = curSheet.getDataValidationHelper();
        String dictSheetName = "字典sheet";

        Workbook workbook = writeWorkbookHolder.getWorkbook();
        // 数据字典的sheet页
        Sheet dictSheet = workbook.createSheet(dictSheetName); 这里是在一开始就创建了sheet///
        // 从第二个工作簿开始隐藏，为了用户的友好性，将字典sheet隐藏掉
        this.index++;
        // 设置隐藏
        workbook.setSheetHidden(this.index, true);
        for (Map.Entry<Integer,String[]> entry : map.entrySet()) {
            // 设置下拉单元格的首行、末行、首列、末列
            CellRangeAddressList rangeAddressList = new CellRangeAddressList(1, 65533, entry.getKey(), entry.getKey());
            int rowLen = entry.getValue().length;
            // 设置字典sheet页的值 每一列一个字典项
            for (int i = 0; i < rowLen; i++) {
                Row row = dictSheet.getRow(i);
                if (row == null) {
                    row = dictSheet.createRow(i);
                }
                row.createCell(entry.getKey()).setCellValue(entry.getValue()[i]);
            }
            String excelColumn = getExcelColumn(entry.getKey());
            // 下拉框数据来源 eg:字典sheet!$B1:$B2
            String refers = dictSheetName + "!$" + excelColumn + "$1:$" + excelColumn + "$" + rowLen;
            // 创建可被其他单元格引用的名称
            Name name = workbook.createName();
            // 设置名称的名字
            name.setNameName("dict" + entry.getKey());
            // 设置公式
            name.setRefersToFormula(refers);
            // 设置引用约束
            DataValidationConstraint constraint = helper.createFormulaListConstraint("dict" + entry.getKey());
            // 设置约束
            DataValidation validation = helper.createValidation(constraint, rangeAddressList);
            // 添加下拉框约束
            writeSheetHolder.getSheet().addValidationData(validation);
            //第一行>文本格式
            CellStyle cellStyle = writeSheetHolder.getSheet().getWorkbook().createCellStyle();
            cellStyle.setDataFormat((short)49);
            writeSheetHolder.getSheet().setDefaultColumnStyle(0,cellStyle);
        }

    }

修改后如下：

public void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
        // 需要设置下拉框的sheet页
        Sheet curSheet = writeSheetHolder.getSheet();
        DataValidationHelper helper = curSheet.getDataValidationHelper();
        for (Map.Entry<Integer,String[]> entry : map.entrySet()) {
            String dictSheetName = "字典sheet"+entry.getKey();

            Workbook workbook = writeWorkbookHolder.getWorkbook();
            // 数据字典的sheet页
            Sheet dictSheet = workbook.createSheet(dictSheetName); 每一个字典项创建一个sheet
            // 设置隐藏
            int hiddenIndex = workbook.getSheetIndex(dictSheetName);
            workbook.setSheetHidden(hiddenIndex, true);
            // 设置下拉单元格的首行、末行、首列、末列
            CellRangeAddressList rangeAddressList = new CellRangeAddressList(1, 65533, entry.getKey(), entry.getKey());
            int rowLen = entry.getValue().length;
            // 设置字典sheet页的值 每一列一个字典项
            for (int i = 0; i < rowLen; i++) {
                Row row = dictSheet.getRow(i);
                if (row == null) {
                    row = dictSheet.createRow(i);
                }
                row.createCell(entry.getKey()).setCellValue(entry.getValue()[i]);
            }
            String excelColumn = getExcelColumn(entry.getKey());
            // 下拉框数据来源 eg:字典sheet!$B1:$B2
            String refers = dictSheetName + "!$" + excelColumn + "$1:$" + excelColumn + "$" + rowLen;
            // 创建可被其他单元格引用的名称
            Name name = workbook.createName();
            // 设置名称的名字
            name.setNameName("dict" + entry.getKey());
            // 设置公式
            name.setRefersToFormula(refers);
            // 设置引用约束
            DataValidationConstraint constraint = helper.createFormulaListConstraint("dict" + entry.getKey());
            // 设置约束
            DataValidation validation = helper.createValidation(constraint, rangeAddressList);
            // 添加下拉框约束
            writeSheetHolder.getSheet().addValidationData(validation);
            //第一行>文本格式
            CellStyle cellStyle = writeSheetHolder.getSheet().getWorkbook().createCellStyle();
            cellStyle.setDataFormat((short)49);
            writeSheetHolder.getSheet().setDefaultColumnStyle(0,cellStyle);
        }
    }

改成这样之后就好了。