From 46386e7a6a447205579d7210790d29f803565b45 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期二, 19 七月 2022 15:02:58 +0800
Subject: [PATCH] excel解析
---
src/main/java/com/whyc/service/ProductBomApprovingService.java | 13 +++++++++----
1 files changed, 9 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/whyc/service/ProductBomApprovingService.java b/src/main/java/com/whyc/service/ProductBomApprovingService.java
index 888f4e6..29e8bfb 100644
--- a/src/main/java/com/whyc/service/ProductBomApprovingService.java
+++ b/src/main/java/com/whyc/service/ProductBomApprovingService.java
@@ -29,12 +29,17 @@
short lastCellNum = row2.getLastCellNum();
for (int i = 2; i < lastRowNum; i++) {
ProductBomApproving bomApproving = new ProductBomApproving();
- for (int j = 0; j < lastCellNum; j++) {
+ for (int j = 1; j < lastCellNum; j++) {
Row row = sheet.getRow(i);
Cell cell = row.getCell(j);
- String cellValue = cell.getStringCellValue();
+ String cellValue = null;
+ Double cellValueInt = 0d;
+ if(i == 9){
+ cellValueInt = cell.getNumericCellValue();
+ }else if(i!=15){
+ cellValue = cell.getStringCellValue();
+ }
switch (j){
- case 0:{}break;
case 1:{bomApproving.setParentCode(cellValue);}break;
case 2:{bomApproving.setParentName(cellValue);}break;
case 3:{bomApproving.setParentModel(cellValue);}break;
@@ -43,7 +48,7 @@
case 6:{bomApproving.setSubName(cellValue);}break;
case 7:{bomApproving.setSubModel(cellValue);}break;
case 8:{bomApproving.setUnit(cellValue);}break;
- case 9:{bomApproving.setQuantity(Integer.parseInt(cellValue));}break;
+ case 9:{bomApproving.setQuantity(cellValueInt.intValue());}break;
case 10:{bomApproving.setProducer(cellValue);}break;
case 11:{bomApproving.setMaterial(cellValue);}break;
case 12:{bomApproving.setThickness(cellValue);}break;
--
Gitblit v1.9.1