| | |
|---|
| | | 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(); |
|---|
| | |
|---|
| | | 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){ |
|---|
