Package org.apache.poi.xssf.eventusermodel

Class XSSFBReader

java.lang.Object

org.apache.poi.xssf.eventusermodel.XSSFReader

org.apache.poi.xssf.eventusermodel.XSSFBReader

public class XSSFBReader
extends XSSFReader

Reader for xlsb files.

Since:

3.16-beta3

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	XSSFBReader.SheetIterator

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
String	getAbsPathMetadata()	In Excel 2013, the absolute path where the file was last saved may be stored in the XSSFBRecordType.BrtAbsPath15 record.
Iterator<InputStream>	getSheetsData()	Returns an Iterator which will let you get at all the different Sheets in turn.
XSSFBStylesTable	getXSSFBStylesTable()

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

getSharedStringsData, getSharedStringsTable, getSheet, getStylesData, getStylesTable, getThemesData, getWorkbookData

Methods inherited from class java.lang.Object

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

Constructor Detail

XSSFBReader

public XSSFBReader(OPCPackage pkg)
            throws IOException,
                   OpenXML4JException

Creates a new XSSFReader, for the given package

Parameters:

pkg - opc package

Throws:

IOException

OpenXML4JException

Method Detail

getAbsPathMetadata

public String getAbsPathMetadata()
                          throws IOException

In Excel 2013, the absolute path where the file was last saved may be stored in the XSSFBRecordType.BrtAbsPath15 record. The equivalent in ooxml is <x15ac:absPath>.

Returns:

absolute path or null if it could not be found.

Throws:

IOException - when there's a problem with the workbook part's stream

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.

Overrides:

getSheetsData in class XSSFReader

Throws:

IOException

InvalidFormatException

getXSSFBStylesTable

public XSSFBStylesTable getXSSFBStylesTable()
                                     throws IOException

Throws:

IOException