基于POI，使用java处理Excel数据

pom文件

        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.12</version>
        </dependency>

实例代码
注意：写入数据后一定要workbook.write && file.flush.close

        Workbook wb = null;
        InputStream is = null;
        Sheet sheet = null;
        Row row = null;

        ArrayList<String> list =new ArrayList<>();
        try {
            is = new FileInputStream(new File(excelPath));
            wb = new XSSFWorkbook(is);
            if (wb != null) {
                sheet = wb.getSheetAt(0);
                int num = sheet.getPhysicalNumberOfRows();
                for (int i = 1; i < num; i++) {
                    row = sheet.getRow(i);
                    for (int j = 0; j <= 5; j++) {
                        //全转为字符串输出
                        if (row.getCell(j) != null) {
                            row.getCell(j).setCellType(Cell.CELL_TYPE_STRING);
                        }
                    }
                    Map<String, Object> map = new HashMap<>();
                    map.put("token", "****");
                    map.put("format", "json");
                    map.put("project", "****");
                    map.put("q", buildSql(row.getCell(3).getStringCellValue()));
                    String result = HttpKit.post("https://****", map).replaceAll(Matcher.quoteReplacement("$"), "");
                    if (StringUtils.isEmpty(result)) {
                        row.createCell(9).setCellValue("无");
                    }
                    System.out.println("已读取第"+i+"行");
                    list.add(row.getCell(3).getStringCellValue());
                }
            }
        } catch (IOException e) {
            e.printStackTrace();
        }finally {
            FileOutputStream fos=new FileOutputStream(excelPath);
            wb.write(fos);
            fos.flush();
            fos.close();
            System.out.println("数据写入完成");
        }
        return list;
    }