poi报表xlsx导入

导入依赖

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

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

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

编写测试

public class POIDemo05 {
    public static void main(String[] args) throws Exception {
        Workbook wb = new XSSFWorkbook("读取xlsx的路径");
        Sheet sheet = wb.getSheetAt(0);

        for (int rowNum = 0; rowNum <=sheet.getLastRowNum(); rowNum++) {
            Row row = sheet.getRow(rowNum);
            StringBuilder sb = new StringBuilder();
            for (int cellNum = 2; cellNum < row.getLastCellNum(); cellNum++) {
                Cell cell = row.getCell(cellNum);
                Object value= getCell(cell);
                sb.append(value).append("-");
            }
            System.out.println(sb.toString());
        }
    }

    private static Object getCell(Cell cell) {
        CellType cellType = cell.getCellType();
        Object value=null;
        switch (cellType){
            case STRING:
                value=cell.getStringCellValue();
                break;
            case BOOLEAN:
                value=cell.getBooleanCellValue();
                break;
            case NUMERIC:
                if(DateUtil.isCellDateFormatted(cell)){
                    value=cell.getDateCellValue();
                }else {
                    value=cell.getNumericCellValue();
                }
                break;
            case FORMULA:
                value=cell.getCellFormula();
                break;
            default:
                break;
        }
        return value;
    }
}