Package com.northconcepts.datapipeline.excel

Class PoiXssfbProvider

java.lang.Object
com.northconcepts.datapipeline.excel.PoiXssfbProvider
All Implemented Interfaces:
DataExceptionContributor
public class PoiXssfbProvider extends Object
Read-only provider for ExcelDocument.ProviderType.POI_XSSFB: reads binary .xlsb sheets from a File, returning each cell as its formatted string.

  • Field Details

  • Constructor Details

    • PoiXssfbProvider

      public PoiXssfbProvider()

  • Method Details

    • openWorkbook

      public void openWorkbook(File file) throws Throwable
      Throws:
      Throwable

    • openWorkbook

      public void openWorkbook(InputStream inputStream)

    • newWorkbook

      public void newWorkbook()

    • close

      public void close()

    • saveWorkbook

      public void saveWorkbook(OutputStream outputStream) throws Throwable
      Throws:
      Throwable

    • startReadingImpl

      protected void startReadingImpl(String sheetName)

    • startReadingImpl

      protected void startReadingImpl(int sheetIndex)

    • readField

      public void readField(int rowIndex, int fieldIndex, Field field)

    • endReadingImpl

      protected void endReadingImpl()

    • startWritingImpl

      protected void startWritingImpl(String sheetName, int sheetIndex)

    • writeField

      public void writeField(int rowIndex, int columnIndex, int recordIndex, int fieldIndex, Field field)

    • setAutofitColumns

      public void setAutofitColumns(int firstColumnIndex, int[] columnCharacterCount)

    • endWritingImpl

      protected void endWritingImpl()

    • getLastRowIndex

      public int getLastRowIndex()

    • getLastColumnIndex

      public int getLastColumnIndex()

    • getCellCount

      public int getCellCount(int rowIndex)

    • isDataFormatSupported

      public boolean isDataFormatSupported()

    • setAutoFilter

      public void setAutoFilter(int firstRow, int firstColumn)

    • getSheetNames

      public String[] getSheetNames()

    • isFreezePaneSupported

      public boolean isFreezePaneSupported()

    • isHyperlinkSupported

      public boolean isHyperlinkSupported()

    • isCellStyleSupported

      public boolean isCellStyleSupported()

    • isEvaluateExpressions

      public boolean isEvaluateExpressions()

    • setEvaluateExpressions

      public com.northconcepts.datapipeline.excel.Provider setEvaluateExpressions(boolean evaluateExpressions)

    • saveWorkbook

      public void saveWorkbook(File file) throws Throwable
      Throws:
      Throwable

    • startReading

      public final void startReading(String sheetName)

    • startReading

      public final void startReading(int sheetIndex)

    • endReading

      public final void endReading()

    • startWriting

      public final void startWriting(String sheetName, int sheetIndex)

    • endWriting

      public final void endWriting()

    • setFreezePane

      protected void setFreezePane()

    • setFreezePaneImpl

      protected void setFreezePaneImpl(int columns, int rows)

    • startRecord

      public void startRecord(Record record, int currentRowIndex)

    • endRecord

      public void endRecord(Record record, int currentRowIndex)

    • setExcelReader

      protected void setExcelReader(ExcelReader excelReader)

    • getExcelReader

      protected ExcelReader getExcelReader()

    • setExcelWriter

      protected void setExcelWriter(ExcelWriter excelWriter)

    • getExcelWriter

      protected ExcelWriter getExcelWriter()

    • initStyles

      public void initStyles()

    • addExceptionProperties

      public DataException addExceptionProperties(DataException exception)
      Description copied from interface: DataExceptionContributor
      Adds this object's current state to a DataException. Since this method is called whenever an exception is thrown, subclasses should override it to add their specific information.
      Specified by:
      addExceptionProperties in interface DataExceptionContributor