读excel

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>3.17</version>
</dependency>

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

//启动时外边程序不能打开excel
public class ReadExcel {
//    @Autowired    PostConstruct 启动写入到类中
//    IHandleAdviceService iHandleAdviceService;

    public static void main(String[] args) throws IOException, InvalidFormatException {
        File xlsFile = new File("C:\\Users\\Administrator\\Desktop\\ag.xlsx");
        // 工作表
        Workbook workbook = WorkbookFactory.create(xlsFile);
        // 表个数。
        int numberOfSheets = workbook.getNumberOfSheets();
        // 遍历表。
        for (int i = 0; i < numberOfSheets; i++) {
            Sheet sheet = workbook.getSheetAt(i);
            // 行数。
            int rowNumbers = sheet.getLastRowNum() + 1;
            // Excel第一行。
            Row temp = sheet.getRow(0);
            if (temp == null) {
                continue;
            }
            int cells = temp.getPhysicalNumberOfCells();
            // 读数据。 不要第一行
            for (int row = 1; row < rowNumbers; row++) {
                Row r = sheet.getRow(row);
                for (int col = 0; col < cells; col++) {
                    System.out.print(r.getCell(col).toString()+" ");
                }
//                HandleAdvice handleAdvice = new HandleAdvice();
//                handleAdvice.setAttackType("WEB攻击检测");
//                handleAdvice.setRuleName(r.getCell(0).toString());
//                handleAdvice.setRiskAnalysis(r.getCell(1).toString());
//                handleAdvice.setHandleAdvice(r.getCell(2).toString());
//                iHandleAdviceService.save(handleAdvice);
                // 换行。
                System.out.println();
            }
        }
    }
}