Package org.apache.poi.xssf.binary

Class XSSFBSheetHandler

java.lang.Object

org.apache.poi.xssf.binary.XSSFBParser

org.apache.poi.xssf.binary.XSSFBSheetHandler

@Internal
public class XSSFBSheetHandler
extends XSSFBParser

Since:

3.16-beta3

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static interface	XSSFBSheetHandler.SheetContentsHandler	You need to implement this to handle the results of the sheet parsing.
static interface	XSSFBSheetHandler.XSSFBSheetContentsHandler	Receives streaming callbacks while XSSFBSheetHandler parses an XLSB sheet.

Constructor Summary

Constructors

Constructor	Description
XSSFBSheetHandler(InputStream is, XSSFBStylesTable styles, XSSFBCommentsTable comments, SharedStrings strings, XSSFBSheetHandler.XSSFBSheetContentsHandler sheetContentsHandler, boolean formulasNotResults)	Creates a handler that forwards native POI cell types to the supplied XSSFBSheetHandler.XSSFBSheetContentsHandler.
XSSFBSheetHandler(InputStream is, XSSFBStylesTable styles, XSSFBCommentsTable comments, SharedStrings strings, XSSFSheetXMLHandler.SheetContentsHandler sheetContentsHandler, DataFormatter dataFormatter, boolean formulasNotResults)	Creates a handler that converts numeric and date cells to formatted strings via DataFormatter.

Method Summary

Modifier and Type	Method	Description
void	handleRecord(int id, byte[] data)	Dispatches a parsed XLSB record to the appropriate specialised handler.

Methods inherited from class org.apache.poi.xssf.binary.XSSFBParser

getMaxRecordLength, parse, setMaxRecordLength

Methods inherited from class java.lang.Object

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

Constructor Details

XSSFBSheetHandler

public XSSFBSheetHandler(InputStream is,
 XSSFBStylesTable styles,
 XSSFBCommentsTable comments,
 SharedStrings strings,
 XSSFBSheetHandler.XSSFBSheetContentsHandler sheetContentsHandler,
 boolean formulasNotResults)

Creates a handler that forwards native POI cell types to the supplied XSSFBSheetHandler.XSSFBSheetContentsHandler.

Select this overload when the consumer expects the raw cell representation rather than formatted strings.

Parameters:

is - XLSB worksheet stream to parse

styles - table providing cell style and number format metadata

comments - optional comments table, may be null

strings - shared strings table used by the sheet

sheetContentsHandler - callback receiving native cell events

Since:

5.5.0

XSSFBSheetHandler

public XSSFBSheetHandler(InputStream is,
 XSSFBStylesTable styles,
 XSSFBCommentsTable comments,
 SharedStrings strings,
 XSSFSheetXMLHandler.SheetContentsHandler sheetContentsHandler,
 DataFormatter dataFormatter,
 boolean formulasNotResults)

Creates a handler that converts numeric and date cells to formatted strings via DataFormatter.

Select this overload when the consumer expects formatted string values rather than raw cell representations.

Parameters:

is - XLSB worksheet stream to parse

styles - table providing cell style and number format metadata

comments - optional comments table, may be null

strings - shared strings table used by the sheet

sheetContentsHandler - callback receiving formatted string values

dataFormatter - formatter applied to numeric and date cells

See Also:

• XSSFBSheetHandler(InputStream, XSSFBStylesTable, XSSFBCommentsTable, SharedStrings, XSSFBSheetContentsHandler, boolean)

Method Details

handleRecord

public void handleRecord(int id,
 byte[] data)
                  throws XSSFBParseException

Dispatches a parsed XLSB record to the appropriate specialised handler.

Specified by:

handleRecord in class XSSFBParser

Parameters:

id - numeric record identifier supplied by XSSFBParser

data - raw record payload

Throws:

XSSFBParseException - if the record cannot be processed according to the XLSB spec

See Also:

• XSSFBRecordType