cn.hutool.poi.excel.sax

Class SheetRidReader

java.lang.Object

org.xml.sax.helpers.DefaultHandler

cn.hutool.poi.excel.sax.SheetRidReader

All Implemented Interfaces:

ContentHandler, DTDHandler, EntityResolver, ErrorHandler

public class SheetRidReader
extends DefaultHandler

在Sax方式读取Excel时，读取sheet标签中sheetId和rid的对应关系，类似于:

 <sheet name="Sheet6" sheetId="4" r:id="rId6"/>
 

读取结果为：

     {"4": "6"}
 

Since:

5.4.4

Author:

looly

Constructor Summary

Constructors

Constructor and Description
SheetRidReader()

Method Summary

Modifier and Type	Method and Description
Integer	getRidByIndex(int index) 通过sheet的序号获取rid
Integer	getRidByIndexBase0(int index) 通过sheet的序号获取rid
Integer	getRidByName(String sheetName) 根据sheet name获取rid，从1开始
Integer	getRidByNameBase0(String sheetName) 根据sheet name获取rid，从0开始
Integer	getRidBySheetId(int sheetId) 根据sheetId获取rid，从1开始
Integer	getRidBySheetIdBase0(int sheetId) 根据sheetId获取rid，从0开始
List<String>	getSheetNames() 获取所有sheet名称
static SheetRidReader	parse(org.apache.poi.xssf.eventusermodel.XSSFReader reader) 从XSSFReader中解析sheet名、sheet id等相关信息
SheetRidReader	read(org.apache.poi.xssf.eventusermodel.XSSFReader xssfReader) 读取Wordkbook的XML中sheet标签中sheetId和rid的对应关系
void	startElement(String uri, String localName, String qName, Attributes attributes)

Methods inherited from class org.xml.sax.helpers.DefaultHandler

characters, endDocument, endElement, endPrefixMapping, error, fatalError, ignorableWhitespace, notationDecl, processingInstruction, resolveEntity, setDocumentLocator, skippedEntity, startDocument, startPrefixMapping, unparsedEntityDecl, warning

Methods inherited from class java.lang.Object

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

Constructor Detail

SheetRidReader

public SheetRidReader()

Method Detail

parse

public static SheetRidReader parse(org.apache.poi.xssf.eventusermodel.XSSFReader reader)

从XSSFReader中解析sheet名、sheet id等相关信息

Parameters:

reader - XSSFReader

Returns:

SheetRidReader

Since:

5.7.17

read

public SheetRidReader read(org.apache.poi.xssf.eventusermodel.XSSFReader xssfReader)

读取Wordkbook的XML中sheet标签中sheetId和rid的对应关系

Parameters:

xssfReader - XSSF读取器

Returns:

this

getRidBySheetId

public Integer getRidBySheetId(int sheetId)

根据sheetId获取rid，从1开始

Parameters:

sheetId - Sheet的ID，从1开始

Returns:

rid，从1开始

getRidBySheetIdBase0

public Integer getRidBySheetIdBase0(int sheetId)

根据sheetId获取rid，从0开始

Parameters:

sheetId - Sheet的ID，从0开始

Returns:

rid，从0开始

Since:

5.5.5

getRidByName

public Integer getRidByName(String sheetName)

根据sheet name获取rid，从1开始

Parameters:

sheetName - Sheet的name

Returns:

rid，从1开始

getRidByNameBase0

public Integer getRidByNameBase0(String sheetName)

根据sheet name获取rid，从0开始

Parameters:

sheetName - Sheet的name

Returns:

rid，从0开始

Since:

5.5.5

getRidByIndex

public Integer getRidByIndex(int index)

通过sheet的序号获取rid

Parameters:

index - 序号，从0开始

Returns:

rid

Since:

5.5.7

getRidByIndexBase0

public Integer getRidByIndexBase0(int index)

通过sheet的序号获取rid

Parameters:

index - 序号，从0开始

Returns:

rid，从0开始

Since:

5.5.7

getSheetNames

public List<String> getSheetNames()

获取所有sheet名称

Returns:

sheet名称

Since:

5.7.17

startElement

public void startElement(String uri,
                         String localName,
                         String qName,
                         Attributes attributes)

Specified by:

startElement in interface ContentHandler

Overrides:

startElement in class DefaultHandler