cn.hutool.poi.excel.sax

Class Excel07SaxReader

java.lang.Object

cn.hutool.poi.excel.sax.Excel07SaxReader

All Implemented Interfaces:

ExcelSaxReader<Excel07SaxReader>

public class Excel07SaxReader
extends Object
implements ExcelSaxReader<Excel07SaxReader>

Sax方式读取Excel文件
Excel2007格式说明见：http://www.cnblogs.com/wangmingshun/p/6654143.html

Since:

3.1.2

Author:

Looly

Field Summary

Fields inherited from interface cn.hutool.poi.excel.sax.ExcelSaxReader

RID_PREFIX, SHEET_NAME_PREFIX

Constructor Summary

Constructors

Constructor and Description
Excel07SaxReader(RowHandler rowHandler) 构造

Method Summary

Modifier and Type	Method and Description
Excel07SaxReader	read(File file, int rid) 开始读取Excel
Excel07SaxReader	read(File file, String idOrRidOrSheetName) 开始读取Excel
Excel07SaxReader	read(InputStream in, int rid) 开始读取Excel，读取结束后并不关闭流
Excel07SaxReader	read(InputStream in, String idOrRidOrSheetName) 开始读取Excel，读取结束后并不关闭流
Excel07SaxReader	read(org.apache.poi.openxml4j.opc.OPCPackage opcPackage, int rid) 开始读取Excel，Sheet编号从0开始计数
Excel07SaxReader	read(org.apache.poi.openxml4j.opc.OPCPackage opcPackage, String idOrRidOrSheetName) 开始读取Excel，Sheet编号从0开始计数
Excel07SaxReader	read(org.apache.poi.xssf.eventusermodel.XSSFReader xssfReader, String idOrRidOrSheetName) 开始读取Excel，Sheet编号从0开始计数
Excel07SaxReader	setRowHandler(RowHandler rowHandler) 设置行处理器

Methods inherited from class java.lang.Object

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

Methods inherited from interface cn.hutool.poi.excel.sax.ExcelSaxReader

read, read, read, read, read

Constructor Detail

Excel07SaxReader

public Excel07SaxReader(RowHandler rowHandler)

构造

Parameters:

rowHandler - 行处理器

Method Detail

setRowHandler

public Excel07SaxReader setRowHandler(RowHandler rowHandler)

设置行处理器

Parameters:

rowHandler - 行处理器

Returns:

this

read

public Excel07SaxReader read(File file,
                             int rid)
                      throws POIException

Description copied from interface: ExcelSaxReader

开始读取Excel

Specified by:

read in interface ExcelSaxReader<Excel07SaxReader>

Parameters:

file - Excel文件

rid - Excel中的sheet rid编号，如果为-1处理所有编号的sheet

Returns:

this

Throws:

POIException - POI异常

read

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

Description copied from interface: ExcelSaxReader

开始读取Excel

Specified by:

read in interface ExcelSaxReader<Excel07SaxReader>

Parameters:

file - Excel文件

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

Returns:

this

Throws:

POIException - POI异常

read

public Excel07SaxReader read(InputStream in,
                             int rid)
                      throws POIException

Description copied from interface: ExcelSaxReader

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

Specified by:

read in interface ExcelSaxReader<Excel07SaxReader>

Parameters:

in - Excel流

rid - Excel中的sheet rid编号，如果为-1处理所有编号的sheet

Returns:

this

Throws:

POIException - POI异常

read

public Excel07SaxReader read(InputStream in,
                             String idOrRidOrSheetName)
                      throws POIException

Description copied from interface: ExcelSaxReader

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

Specified by:

read in interface ExcelSaxReader<Excel07SaxReader>

Parameters:

in - Excel流

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

Returns:

this

Throws:

POIException - POI异常

read

public Excel07SaxReader read(org.apache.poi.openxml4j.opc.OPCPackage opcPackage,
                             int rid)
                      throws POIException

开始读取Excel，Sheet编号从0开始计数

Parameters:

opcPackage - OPCPackage，Excel包，读取后不关闭

rid - Excel中的sheet rid编号，如果为-1处理所有编号的sheet

Returns:

this

Throws:

POIException - POI异常

read

public Excel07SaxReader read(org.apache.poi.openxml4j.opc.OPCPackage opcPackage,
                             String idOrRidOrSheetName)
                      throws POIException

开始读取Excel，Sheet编号从0开始计数

Parameters:

opcPackage - OPCPackage，Excel包，读取后不关闭

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

Returns:

this

Throws:

POIException - POI异常

read

public Excel07SaxReader read(org.apache.poi.xssf.eventusermodel.XSSFReader xssfReader,
                             String idOrRidOrSheetName)
                      throws POIException

开始读取Excel，Sheet编号从0开始计数

Parameters:

xssfReader - XSSFReader，Excel读取器

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

Returns:

this

Throws:

POIException - POI异常

Since:

5.4.4