com.github.liaochong.myexcel.core

接口 XSSFSheetXMLHandler.SheetContentsHandler

封闭类:

XSSFSheetXMLHandler

public static interface XSSFSheetXMLHandler.SheetContentsHandler

You need to implement this to handle the results of the sheet parsing.

方法概要

限定符和类型	方法和说明
void	cell(String cellReference, String formattedValue, org.apache.poi.xssf.usermodel.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	endSheet() 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

方法详细资料

startRow

void startRow(int rowNum)

A row with the (zero based) row number has started

参数:

rowNum - rowNum

endRow

void endRow(int rowNum)

A row with the (zero based) row number has ended

参数:

rowNum - rowNum

cell

void cell(String cellReference,
          String formattedValue,
          org.apache.poi.xssf.usermodel.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.

参数:

cellReference - cellReference

comment - comment

formattedValue - formattedValue

headerFooter

default void headerFooter(String text,
                          boolean isHeader,
                          String tagName)

A header or footer has been encountered

参数:

isHeader - isHeader

tagName - tagName

text - text

endSheet

default void endSheet()

Signal that the end of a sheet was been reached