com.github.pjfanning.xlsx.impl.ooxml

Class OoxmlReader

java.lang.Object

org.apache.poi.xssf.eventusermodel.XSSFReader

com.github.pjfanning.xlsx.impl.ooxml.OoxmlReader

@Internal
public class OoxmlReader
extends org.apache.poi.xssf.eventusermodel.XSSFReader

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	OoxmlReader.OoxmlSheetIterator Iterator over sheet data.

Nested classes/interfaces inherited from class org.apache.poi.xssf.eventusermodel.XSSFReader

org.apache.poi.xssf.eventusermodel.XSSFReader.SheetIterator, org.apache.poi.xssf.eventusermodel.XSSFReader.XMLSheetRefReader, org.apache.poi.xssf.eventusermodel.XSSFReader.XSSFSheetRef

Field Summary

Fields inherited from class org.apache.poi.xssf.eventusermodel.XSSFReader

pkg, useReadOnlySharedStringsTable, workbookPart

Constructor Summary

Constructors

Constructor and Description
OoxmlReader(StreamingWorkbookReader streamingWorkbookReader, org.apache.poi.openxml4j.opc.OPCPackage pkg, boolean strictOoxmlChecksNeeded) Creates a new XSSFReader, for the given package

Method Summary

Modifier and Type	Method and Description
org.apache.poi.xssf.model.SharedStrings	getSharedStrings(StreamingReader.Builder builder) Opens up the Shared Strings Table, parses it, and returns a handy object for working with shared strings.
org.apache.poi.xssf.model.SharedStringsTable	getSharedStringsTable() Opens up the Shared Strings Table, parses it, and returns a handy object for working with shared strings.
OoxmlReader.OoxmlSheetIterator	getSheetsData() Returns an Iterator which will let you get at all the different Sheets in turn.
org.apache.poi.xssf.model.StylesTable	getStylesTable() Opens up the Styles Table, parses it, and returns a handy object for working with cell styles

Methods inherited from class org.apache.poi.xssf.eventusermodel.XSSFReader

getSharedStringsData, getSheet, getStylesData, getThemesData, getWorkbookData, setUseReadOnlySharedStringsTable, useReadOnlySharedStringsTable

Methods inherited from class java.lang.Object

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

Constructor Detail

OoxmlReader

@Internal
public OoxmlReader(StreamingWorkbookReader streamingWorkbookReader,
                             org.apache.poi.openxml4j.opc.OPCPackage pkg,
                             boolean strictOoxmlChecksNeeded)
                      throws java.io.IOException,
                             org.apache.poi.openxml4j.exceptions.OpenXML4JException

Creates a new XSSFReader, for the given package

Throws:

java.io.IOException

org.apache.poi.openxml4j.exceptions.OpenXML4JException

Method Detail

getSharedStringsTable

public org.apache.poi.xssf.model.SharedStringsTable getSharedStringsTable()
                                                                   throws java.io.IOException

Opens up the Shared Strings Table, parses it, and returns a handy object for working with shared strings.

Overrides:

getSharedStringsTable in class org.apache.poi.xssf.eventusermodel.XSSFReader

Throws:

java.io.IOException

getSharedStrings

public org.apache.poi.xssf.model.SharedStrings getSharedStrings(StreamingReader.Builder builder)
                                                         throws java.io.IOException,
                                                                org.xml.sax.SAXException

Opens up the Shared Strings Table, parses it, and returns a handy object for working with shared strings.

Throws:

java.io.IOException

org.xml.sax.SAXException

getStylesTable

public org.apache.poi.xssf.model.StylesTable getStylesTable()
                                                     throws java.io.IOException,
                                                            org.apache.poi.openxml4j.exceptions.InvalidFormatException

Opens up the Styles Table, parses it, and returns a handy object for working with cell styles

Overrides:

getStylesTable in class org.apache.poi.xssf.eventusermodel.XSSFReader

Throws:

java.io.IOException

org.apache.poi.openxml4j.exceptions.InvalidFormatException

getSheetsData

public OoxmlReader.OoxmlSheetIterator getSheetsData()
                                             throws java.io.IOException

Returns an Iterator which will let you get at all the different Sheets in turn. Each sheet's InputStream is only opened when fetched from the Iterator. It's up to you to close the InputStreams when done with each one.

Overrides:

getSheetsData in class org.apache.poi.xssf.eventusermodel.XSSFReader

Throws:

java.io.IOException