packagecom.example.demo.utils;importorg.apache.poi.openxml4j.exceptions.InvalidFormatException;importorg.apache.poi.openxml4j.exceptions.OpenXML4JException;importorg.apache.poi.openxml4j.opc.OPCPackage;importorg.apache.poi.ss.usermodel.DataFormatter;importorg.apache.poi.xssf.binary.XSSFBSharedStringsTable;importorg.apache.poi.xssf.binary.XSSFBSheetHandler;importorg.apache.poi.xssf.binary.XSSFBStylesTable;importorg.apache.poi.xssf.eventusermodel.XSSFBReader;importorg.xml.sax.SAXException;importjava.io.IOException;importjava.io.InputStream;importjava.util.ArrayList;importjava.util.List;importjava.util.Objects;/**
* @author xinlan
* @version 1.0
* @date 2023/1/29 21:15
*/publicclassExcelXlsbFileUtils{privatestaticfinalString filePath ="D:\\Documents\\WeChat Files\\wxid_cnm3kxiloquj21\\FileStorage\\File\\2023-01\\CLARKSONS WAF VLCC POSITION UPDATED 05 JAN 2023.xlsb";publicstaticvoidmain(String[] args){callXLToList(filePath);}staticvoidcallXLToList(String xlsbFileName){OPCPackage pkg;try{
pkg =OPCPackage.open(xlsbFileName);XSSFBReader r =newXSSFBReader(pkg);XSSFBSharedStringsTable sst =newXSSFBSharedStringsTable(pkg);XSSFBStylesTable xssfbStylesTable = r.getXSSFBStylesTable();XSSFBReader.SheetIterator it =(XSSFBReader.SheetIterator) r.getSheetsData();List<XLSB2Lists> workBookAsList =newArrayList<>();int sheetNr =1;XLSB2Lists testSheetHandler =newXLSB2Lists();while(it.hasNext()){InputStream is = it.next();String name = it.getSheetName();XSSFBSheetHandler sheetHandler =newXSSFBSheetHandler(is,
xssfbStylesTable,
it.getXSSFBSheetComments(),
sst, testSheetHandler,newDataFormatter(),false);
sheetHandler.parse();
sheetNr++;// Add parsed sheet to workbook list
workBookAsList.add(testSheetHandler);}List<Book> list = testSheetHandler.list;System.out.println("========================");for(Book book : list){if(!Objects.isNull(book)){System.out.println("book.toString() = "+ book.toString());}}}catch(InvalidFormatException e){// TODO Please do your catch hier
e.printStackTrace();}catch(IOException e){// TODO Please do your catch hier
e.printStackTrace();}catch(OpenXML4JException e){// TODO Please do your catch hier
e.printStackTrace();}catch(SAXException e){// TODO Please do your catch hier
e.printStackTrace();}}}