java.lang.Object
- org.apache.poi.xssf.eventusermodel.XSSFReader

Direct Known Subclasses:

XSSFBReader
```
public class XSSFReader
extends Object
```
This class makes it easy to get at individual parts of an OOXML .xlsx file, suitable for low memory sax parsing or similar. It makes up the core part of the EventUserModel support for XSSF.

Nested Class Summary

Nested Classes
Modifier and Type Class Description

static class XSSFReader.SheetIterator
Iterator over sheet data.

Constructor Summary

Constructors
Constructor Description

XSSFReader(OPCPackage pkg)
Creates a new XSSFReader, for the given package

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`InputStream`	`getSharedStringsData()`	Returns an InputStream to read the contents of the shared strings table.
`SharedStringsTable`	`getSharedStringsTable()`	Opens up the Shared Strings Table, parses it, and returns a handy object for working with shared strings.
`InputStream`	`getSheet(String relId)`	Returns an InputStream to read the contents of the specified Sheet.
`Iterator<InputStream>`	`getSheetsData()`	Returns an Iterator which will let you get at all the different Sheets in turn.
`InputStream`	`getStylesData()`	Returns an InputStream to read the contents of the styles table.
`StylesTable`	`getStylesTable()`	Opens up the Styles Table, parses it, and returns a handy object for working with cell styles
`InputStream`	`getThemesData()`	Returns an InputStream to read the contents of the themes table.
`InputStream`	`getWorkbookData()`	Returns an InputStream to read the contents of the main Workbook, which contains key overall data for the file, including sheet definitions.

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

XSSFReader

public XSSFReader(OPCPackage pkg)
           throws IOException,
                  OpenXML4JException

Creates a new XSSFReader, for the given package

Throws:: IOException; OpenXML4JException

Method Detail

getSharedStringsTable

public SharedStringsTable getSharedStringsTable()
                                         throws IOException,
                                                InvalidFormatException

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

Throws:: IOException; InvalidFormatException

getStylesTable

public StylesTable getStylesTable()
                           throws IOException,
                                  InvalidFormatException

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

Throws:: IOException; InvalidFormatException

getSharedStringsData

public InputStream getSharedStringsData()
                                 throws IOException,
                                        InvalidFormatException

Returns an InputStream to read the contents of the shared strings table.

Throws:: IOException; InvalidFormatException

getStylesData

public InputStream getStylesData()
                          throws IOException,
                                 InvalidFormatException

Returns an InputStream to read the contents of the styles table.

Throws:: IOException; InvalidFormatException

getThemesData

public InputStream getThemesData()
                          throws IOException,
                                 InvalidFormatException

Returns an InputStream to read the contents of the themes table.

Throws:: IOException; InvalidFormatException

getWorkbookData
```
public InputStream getWorkbookData()
                            throws IOException,
                                   InvalidFormatException
```
Returns an InputStream to read the contents of the main Workbook, which contains key overall data for the file, including sheet definitions.

Throws:

IOException

InvalidFormatException

getSheet
```
public InputStream getSheet(String relId)
                     throws IOException,
                            InvalidFormatException
```
Returns an InputStream to read the contents of the specified Sheet.

Parameters:

relId - The relationId of the sheet, from a r:id on the workbook

Throws:

IOException

InvalidFormatException

getSheetsData
```
public Iterator<InputStream> getSheetsData()
                                    throws IOException,
                                           InvalidFormatException
```
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.

Throws:

IOException

InvalidFormatException

Class XSSFReader

Nested Class Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object