[快速上手] Java项目增加excel解析功能

• 一个demo
• • maven依赖
  • excel解析类
• 实际开发中的问题和解决办法

            org.apache.poi
            poi
            5.2.2




   org.apache.poi
   poi-ooxml
   5.2.2




   org.apache.logging.log4j
   log4j-core
   2.17.2

可直接粘贴部分或整个类到自己的项目中，然后根据自己的需求来做功能调用

public class ExcelResolve {

    private Workbook workbook;

    public ExcelResolve(String path) throws IOException {
        workbook = path.endsWith(".xls") ? new HSSFWorkbook(new FileInputStream(path)) : new XSSFWorkbook(path);
    }

    
    public Object[][] getSheetData(String name) {
        Sheet sheet = workbook.getSheet(name);

        // 逐行遍历
        List res = new ArrayList<>();
        sheet.forEach(row -> res.add(getRowData(row)));
        return res.toArray(new Object[][]{});
    }

    
    private Object[] getRowData(Row row) {
        // 跳过空行
        if (row.getLastCellNum() == -1) {
            return null;
        }

        List