bom审批-excel解析

whycxzp

2022-07-19 aa7f1f1d411bbe4ab0c59c27fbf8bc582ab1ae3e

bom审批-excel解析

 src/main/java/com/whyc/service/ProductBomApprovingService.java

@@ -17,14 +17,15 @@
        List<ProductBomApproving> list = new LinkedList<>();
        Workbook workbook = null;
        workbook = WorkbookFactory.create(inputStream);
        List<? extends PictureData> allPictures = workbook.getAllPictures();
        inputStream.close();
        //取第一个sheet表
        Sheet sheet = workbook.getSheetAt(0);
        int lastRowNum = sheet.getLastRowNum();
        //取第二行,并以第二行开始
        Row row2 = sheet.getRow(1);
        //取第三行,并以第三行开始
        Row row2 = sheet.getRow(2);
        short lastCellNum = row2.getLastCellNum();
        for (int i = 1; i < lastRowNum; i++) {
        for (int i = 2; i < lastRowNum; i++) {
            ProductBomApproving bomApproving = new ProductBomApproving();
            for (int j = 0; j < lastCellNum; j++) {
                Row row = sheet.getRow(i);
@@ -47,8 +48,13 @@
                    case 13:{bomApproving.setSurfaceDetail(cellValue);}break;
                    case 14:{bomApproving.setNotes(cellValue);}break;
                    case 15:{
                        //图片
                        System.out.println("图片列:"+cellValue);
                        //图片,从0开始,到图片size为止
                        int k = i-2;
                        if(k<allPictures.size()){
                            PictureData pictureData = allPictures.get(k);
                            //图片
                            bomApproving.setPictureUrl(bomApproving.getSubModel()+"."+pictureData.suggestFileExtension());
                        }
                    }break;
                }
            }