From bace2ae27da05bcdcca2bc3b1ee543b93ac7e3f7 Mon Sep 17 00:00:00 2001
From: longyvfengyun <496960745@qq.com>
Date: 星期二, 19 七月 2022 15:16:42 +0800
Subject: [PATCH] excel解析
---
src/main/java/com/whyc/service/ProductBomApprovingService.java | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/whyc/service/ProductBomApprovingService.java b/src/main/java/com/whyc/service/ProductBomApprovingService.java
index 29e8bfb..70e49c1 100644
--- a/src/main/java/com/whyc/service/ProductBomApprovingService.java
+++ b/src/main/java/com/whyc/service/ProductBomApprovingService.java
@@ -25,7 +25,7 @@
Sheet sheet = workbook.getSheetAt(0);
int lastRowNum = sheet.getLastRowNum();
//鍙栫涓夎,骞朵互绗笁琛屽紑濮�
- Row row2 = sheet.getRow(2);
+ Row row2 = sheet.getRow(1);
short lastCellNum = row2.getLastCellNum();
for (int i = 2; i < lastRowNum; i++) {
ProductBomApproving bomApproving = new ProductBomApproving();
@@ -34,9 +34,9 @@
Cell cell = row.getCell(j);
String cellValue = null;
Double cellValueInt = 0d;
- if(i == 9){
+ if(j == 9){
cellValueInt = cell.getNumericCellValue();
- }else if(i!=15){
+ }else if(j!=15){
cellValue = cell.getStringCellValue();
}
switch (j){
--
Gitblit v1.9.1