导入

    compile group: 'org.apache.poi', name: 'poi', version: '4.1.2'
    compile group: 'org.apache.poi', name: 'poi-ooxml', version: '4.1.2'

导入

Workbook workbook = new XSSFWorkbook(inputStream);
Sheet sheet = workbook.getSheetAt(0);
for (Row row : sheet) {
    Long v1 = Long.valueOf(row.getCell(0).getStringCellValue());
        Long v2 = Long.valueOf(row.getCell(1).getStringCellValue());
        String v3 = row.getCell(2).getStringCellValue();
        String v4=row.getCell(3).getStringCellValue();
}

导出

Workbook workbook = new XSSFWorkbook(templateFileInputStream);
            Sheet sheet = workbook.getSheetAt(0);
            int rowBase = 0;
            int rowIndex = 0;
            for (Rule rule : ruleList) {
                Row row = sheet.createRow(rowBase + rowIndex);
                Cell cell0 = row.createCell(0, CellType.STRING);
                cell0.setCellValue(rule.getCategory());
                Cell cell1 = row.createCell(1, CellType.STRING);
                cell1.setCellValue(rule.getRuleContent());
                Cell cell2 = row.createCell(2, CellType.NUMERIC);
                cell2.setCellValue(rule.getPrimaryValue());
                Cell cell3 = row.createCell(3, CellType.NUMERIC);
                cell3.setCellValue(rule.getSecondaryValue());
                rowIndex++;
            }
            templateFileInputStream.close();
            workbook.write(outputStream);
            workbook.close();