org.dromara.hutool.poi.excel.sax

Class Excel03SaxReader

java.lang.Object

org.dromara.hutool.poi.excel.sax.Excel03SaxReader

All Implemented Interfaces:

org.apache.poi.hssf.eventusermodel.HSSFListener, ExcelSaxReader<Excel03SaxReader>

public class Excel03SaxReader
extends Object
implements org.apache.poi.hssf.eventusermodel.HSSFListener, ExcelSaxReader<Excel03SaxReader>

Excel2003格式的事件-用户模型方式读取器，在Hutool中，统一将此归类为Sax读取
参考：http://www.cnblogs.com/wshsdlau/p/5643862.html

Author:

looly

Field Summary

Fields inherited from interface org.dromara.hutool.poi.excel.sax.ExcelSaxReader

RID_PREFIX, SHEET_NAME_PREFIX

Constructor Summary

Constructors

Constructor and Description
Excel03SaxReader(RowHandler rowHandler) 构造

Method Summary

Modifier and Type	Method and Description
int	getSheetIndex() 获得Sheet序号，如果处理所有sheet，获得最大的Sheet序号，从0开始
String	getSheetName() 获得Sheet名，如果处理所有sheet，获得后一个Sheet名，从0开始
void	processRecord(org.apache.poi.hssf.record.Record record) HSSFListener 监听方法，处理 Record
Excel03SaxReader	read(File file, String idOrRidOrSheetName) 开始读取Excel
Excel03SaxReader	read(InputStream excelStream, String idOrRidOrSheetName) 开始读取Excel，读取结束后并不关闭流
Excel03SaxReader	read(org.apache.poi.poifs.filesystem.POIFSFileSystem fs, String idOrRidOrSheetName) 读取

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.dromara.hutool.poi.excel.sax.ExcelSaxReader

read, read, read, read, read, read, read

Constructor Detail

Excel03SaxReader

public Excel03SaxReader(RowHandler rowHandler)

构造

Parameters:

rowHandler - 行处理器

Method Detail

read

public Excel03SaxReader read(File file,
                             String idOrRidOrSheetName)
                      throws POIException

Description copied from interface: ExcelSaxReader

开始读取Excel

Specified by:

read in interface ExcelSaxReader<Excel03SaxReader>

Parameters:

file - Excel文件

idOrRidOrSheetName - Excel中的sheet id或者rid编号或sheet名称，rid必须加rId前缀，例如rId1，如果为-1处理所有编号的sheet

Returns:

this

Throws:

POIException - POI异常

read

public Excel03SaxReader read(InputStream excelStream,
                             String idOrRidOrSheetName)
                      throws POIException

Description copied from interface: ExcelSaxReader

开始读取Excel，读取结束后并不关闭流

Specified by:

read in interface ExcelSaxReader<Excel03SaxReader>

Parameters:

excelStream - Excel流

idOrRidOrSheetName - Excel中的sheet id或者rid编号，rid必须加rId前缀，例如rId1，如果为-1处理所有编号的sheet

Returns:

this

Throws:

POIException - POI异常

read

public Excel03SaxReader read(org.apache.poi.poifs.filesystem.POIFSFileSystem fs,
                             String idOrRidOrSheetName)
                      throws POIException

读取

Parameters:

fs - POIFSFileSystem

idOrRidOrSheetName - sheet id或者rid编号或sheet名称，从0开始，rid必须加rId前缀，例如rId0，如果为-1处理所有编号的sheet

Returns:

this

Throws:

POIException - IO异常包装

getSheetIndex

public int getSheetIndex()

获得Sheet序号，如果处理所有sheet，获得最大的Sheet序号，从0开始

Returns:

sheet序号

getSheetName

public String getSheetName()

获得Sheet名，如果处理所有sheet，获得后一个Sheet名，从0开始

Returns:

Sheet名

processRecord

public void processRecord(org.apache.poi.hssf.record.Record record)

HSSFListener 监听方法，处理 Record

Specified by:

processRecord in interface org.apache.poi.hssf.eventusermodel.HSSFListener

Parameters:

record - 记录