Class EventWorkbookBuilder
java.lang.Object
org.apache.poi.hssf.eventusermodel.EventWorkbookBuilder
When working with the EventUserModel, if you want to
process formulas, you need an instance of
InternalWorkbook to pass to a HSSFWorkbook,
to finally give to HSSFFormulaParser,
and this will build you stub ones.
Since you're working with the EventUserModel, you
wouldn't want to get a full InternalWorkbook and
HSSFWorkbook, as they would eat too much memory.
Instead, you should collect a few key records as they
go past, then call this once you have them to build a
stub InternalWorkbook, and from that a stub
HSSFWorkbook, to use with the HSSFFormulaParser.
The records you should collect are:
* ExternSheetRecord
* BoundSheetRecord
You should probably also collect SSTRecord,
but it's not required to pass this in.
To help, this class includes a HSSFListener wrapper
that will do the collecting for you.-
Nested Class Summary
Nested ClassesModifier and TypeClassDescriptionstatic classA wrapping HSSFListener which will collectBoundSheetRecords andExternSheetRecords as they go past, so you can create a StubInternalWorkbookfrom them once required. -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic InternalWorkbookcreateStubWorkbook(ExternSheetRecord[] externs, BoundSheetRecord[] bounds) Creates a stub workbook from the supplied records, suitable for use with theHSSFFormulaParserstatic InternalWorkbookcreateStubWorkbook(ExternSheetRecord[] externs, BoundSheetRecord[] bounds, SSTRecord sst) Creates a stub Workbook from the supplied records, suitable for use with theHSSFFormulaParser
-
Constructor Details
-
EventWorkbookBuilder
public EventWorkbookBuilder()
-
-
Method Details
-
createStubWorkbook
public static InternalWorkbook createStubWorkbook(ExternSheetRecord[] externs, BoundSheetRecord[] bounds, SSTRecord sst) Creates a stub Workbook from the supplied records, suitable for use with theHSSFFormulaParser- Parameters:
externs- The ExternSheetRecords in your filebounds- The BoundSheetRecords in your filesst- The SSTRecord in your file.- Returns:
- A stub Workbook suitable for use with
HSSFFormulaParser
-
createStubWorkbook
public static InternalWorkbook createStubWorkbook(ExternSheetRecord[] externs, BoundSheetRecord[] bounds) Creates a stub workbook from the supplied records, suitable for use with theHSSFFormulaParser- Parameters:
externs- The ExternSheetRecords in your filebounds- The BoundSheetRecords in your file- Returns:
- A stub Workbook suitable for use with
HSSFFormulaParser
-