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 class
A wrapping HSSFListener which will collectBoundSheetRecord
s andExternSheetRecord
s as they go past, so you can create a StubInternalWorkbook
from them once required. -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic InternalWorkbook
createStubWorkbook
(ExternSheetRecord[] externs, BoundSheetRecord[] bounds) Creates a stub workbook from the supplied records, suitable for use with theHSSFFormulaParser
static InternalWorkbook
createStubWorkbook
(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
-