monitorjbl与poi读取excel的区别

monitorjbl读取excel

monitorjbl只能读取xlsx文件，如果读取xls文件的话:

Caused by: org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException: The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF)

monitorjbl有缓存机制

Workbook wb = StreamingReader.builder()
        .rowCacheSize(50000)  //缓存到内存中的行数
        .bufferSize(4096)  //缓存到内存的字节大小，默认是1024
        .open(in); //open可传入InputStream及子类和File类
Sheet sheet = wb.getSheetAt(0); // 读取第一张sheet页

不可以使用sheet.getRow(i)方式来获取指定行，monitorjbl并未读取整个表格文件

Caused by: java.lang.UnsupportedOperationException
 at com.monitorjbl.xlsx.impl.StreamingSheet.getRow(StreamingSheet.java:102)

只能用for (Row row : sheet) {…}循环方式

不能使用setCellType对某个单元格设定数据类型

Caused by: com.monitorjbl.xlsx.exceptions.NotSupportedException
 at com.monitorjbl.xlsx.impl.StreamingCell.setCellType(StreamingCell.java:322)

获取单元格内容时，不能直接使用row.getCell(i)，得到的是对象地址（即便单元格为空，row.getCell(i)仍有地址），要用getStringCellValue()、getNumericCellValue()等方法来判断是否为空及获取内容。

for (Row row : sheet) {
   
  System.out.println("第A列：" + row.getCell(0));
  System.out.println("第A列：" + row.getCell(0).getStringCellValue());
  System.out.println("第A列：" + row.getCell(0).getNumericCellValue());

  System.out.println("第B列：" + row.getCell(1).getStringCellValue());
  System.out.println("第B列：" + row.getCell(1).getNumericCellValue());

  System.out.println("第C列：" + row.getCell(2).getStringCellValue());
  System.out.println("第C列：" + row.getCell(2).getNumericCellValue());
  System.out.println("第C列：" + row.getCell(2).getDateCellValue());

  Sy