// 导入 @Transactional public Map<String, Object> importByExcel(MultipartFile file, LoginUser loginUser) { Map<String, Object> result = new HashMap<>(); try { ExcelReader2 excelReader = new ExcelReader2(file.getInputStream(), 0, 0, 0); String mes = ""; String s = excelReader.readRow(0).get(0).getValue().toString(); boolean a = "合同信息表".equals(s); if (!a) { result.put(Constants.SUCCESS, false); result.put("mes", "模板错误,请重新下载!"); return result; } // 读取表中数据转换为实体类 List<RelateProjectInfo> list = excelReader.read(RelateProjectInfo.class); list.remove(0); log.info("项目信息表----" + list); for (int i = 0; i < list.size(); i++) { RelateProjectInfo relateProjectInfo = new RelateProjectInfo(); String contractNo = cellVal(excelReader.readRow(i + 2).get(1).getValue()); String contractName = cellVal(excelReader.readRow(i + 2).get(2).getValue()); String supplierCode = cellVal(excelReader.readRow(i + 2).get(3).getValue()); String supplierName = cellVal(excelReader.readRow(i + 2).get(4).getValue()); String projectUnitCode = cellVal(excelReader.readRow(i + 2).get(5).getValue()); String projectUnitName = cellVal(excelReader.readRow(i + 2).get(6).getValue()); String actualCommencementDate = cellVal(excelReader.readRow(i + 2).get(7).getValue()); String estimatedCompletionDate = cellVal(excelReader.readRow(i + 2).get(8).getValue()); String competentDepartment = cellVal(excelReader.readRow(i + 2).get(9).getValue()); String personLiable = cellVal(excelReader.readRow(i + 2).get(10).getValue()); String tel = cellVal(excelReader.readRow(i + 2).get(11).getValue()); String projectLocation = cellVal(excelReader.readRow(i + 2).get(12).getValue()); String operationContent = cellVal(excelReader.readRow(i + 2).get(13).getValue()); String projectNature = cellVal(excelReader.readRow(i + 2).get(14).getValue()); String professionalClassification = cellVal(excelReader.readRow(i + 2).get(15).getValue()); String projectNo = cellVal(excelReader.readRow(i + 2).get(16).getValue()); String projectName = cellVal(excelReader.readRow(i + 2).get(17).getValue()); String engineeringNo = cellVal(excelReader.readRow(i + 2).get(18).getValue())
Excel表格导入时,表格中数据是科学计数法,后端转换成数字
最新推荐文章于 2024-02-13 23:20:02 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)