Interface XSSFSheetXMLHandler.SheetContentsHandler

All Known Subinterfaces:
XSSFBSheetHandler.SheetContentsHandler
All Known Implementing Classes:
XSSFEventBasedExcelExtractor.SheetTextExtractor
Enclosing class:
XSSFSheetXMLHandler

public static interface XSSFSheetXMLHandler.SheetContentsHandler
You need to implement this to handle the results of the sheet parsing.
  • Method Summary

    Modifier and Type
    Method
    Description
    void
    cell(String cellReference, String formattedValue, XSSFComment comment)
    A cell, with the given formatted value (may be null), and possibly a comment (may be null), was encountered.
    void
    endRow(int rowNum)
    A row with the (zero based) row number has ended
    default void
    Signal that the end of a sheet was been reached
    default void
    headerFooter(String text, boolean isHeader, String tagName)
    A header or footer has been encountered
    void
    startRow(int rowNum)
    A row with the (zero based) row number has started
  • Method Details

    • startRow

      void startRow(int rowNum)
      A row with the (zero based) row number has started
    • endRow

      void endRow(int rowNum)
      A row with the (zero based) row number has ended
    • cell

      void cell(String cellReference, String formattedValue, XSSFComment comment)
      A cell, with the given formatted value (may be null), and possibly a comment (may be null), was encountered. Sheets that have missing or empty cells may result in sparse calls to cell. See the code in src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java for an example of how to handle this scenario.
    • headerFooter

      default void headerFooter(String text, boolean isHeader, String tagName)
      A header or footer has been encountered
    • endSheet

      default void endSheet()
      Signal that the end of a sheet was been reached