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 TypeMethodDescriptionvoid
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 endeddefault void
endSheet()
Signal that the end of a sheet was been reacheddefault void
headerFooter
(String text, boolean isHeader, String tagName) A header or footer has been encounteredvoid
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
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 tocell
. See the code insrc/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
for an example of how to handle this scenario. -
endSheet
default void endSheet()Signal that the end of a sheet was been reached
-