From a9b4e8e7761359060b73edb86e36fd169b618b56 Mon Sep 17 00:00:00 2001 From: ludc Date: 星期四, 02 十一月 2023 23:52:36 +0800 Subject: [PATCH] 基础码段增加前缀后缀;主数据历史数据导入,模板下载设置编号列为文本类型 --- Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/poi/util/ExcelUtil.java | 29 ++++++++++------------------- 1 files changed, 10 insertions(+), 19 deletions(-) diff --git a/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/poi/util/ExcelUtil.java b/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/poi/util/ExcelUtil.java index 0e819d8..7272b62 100644 --- a/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/poi/util/ExcelUtil.java +++ b/Source/UBCS/ubcs-service-api/ubcs-util-api/src/main/java/com/vci/ubcs/starter/poi/util/ExcelUtil.java @@ -20,23 +20,7 @@ import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.HSSFColor; import org.apache.poi.hssf.util.HSSFColor.HSSFColorPredefined; -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.CellValue; -import org.apache.poi.ss.usermodel.DataValidation; -import org.apache.poi.ss.usermodel.DataValidationConstraint; -import org.apache.poi.ss.usermodel.DateUtil; -import org.apache.poi.ss.usermodel.Font; -import org.apache.poi.ss.usermodel.FormulaEvaluator; -import org.apache.poi.ss.usermodel.HorizontalAlignment; -import org.apache.poi.ss.usermodel.Name; -import org.apache.poi.ss.usermodel.RichTextString; -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.usermodel.*; import org.apache.poi.ss.util.CellRangeAddress; import org.apache.poi.ss.util.CellRangeAddressList; import org.apache.poi.xssf.usermodel.XSSFDataValidation; @@ -290,7 +274,7 @@ Sheet sheet = getSheetByWorkbook(finalWb, sheetName); try { - writeDataToCell(sheet, excelDataList); + writeDataToCell(sheet, excelDataList,workbook); } catch (VciBaseException var6) { IOUtils.closeQuietly(os); throw var6; @@ -531,7 +515,7 @@ return cell; } - private static void writeDataToCell(Sheet sheet, List<WriteExcelData> excelDataList) throws VciBaseException { + private static void writeDataToCell(Sheet sheet, List<WriteExcelData> excelDataList,Workbook workbook) throws VciBaseException { if (sheet != null && !CollectionUtils.isEmpty(excelDataList)) { List<WriteExcelData> mergedDataList = new ArrayList(); excelDataList.stream().forEach((ed) -> { @@ -540,6 +524,13 @@ if (ed.isMerged() && (ed.getRowTo() > ed.getRow() || ed.getColTo() > ed.getCol())) { mergedDataList.add(ed); } + if("id".equalsIgnoreCase(ed.getObjCode())){ + //CellStyle textStyle = workbook.createCellStyle(); + HSSFDataFormat format = (HSSFDataFormat)sheet.getWorkbook().createDataFormat(); + Row copyStyleRow = sheet.getRow(ed.getRow()); + cell = copyStyleRow.getCell(ed.getCol()); + cell.getCellStyle().setDataFormat(format.getFormat("@")); + } copyStyle(sheet, cell, ed); if (ed.isReadOnly() && ed.getObj() != null && !(ed.getObj() instanceof RichTextString) && CollectionUtils.isEmpty(ed.getValidationDataList())) { -- Gitblit v1.9.3