org.apache.poi.hssf.eventusermodel
Class EventWorkbookBuilder
java.lang.Object
org.apache.poi.hssf.eventusermodel.EventWorkbookBuilder
public class EventWorkbookBuilder
- extends java.lang.Object
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.
| Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
EventWorkbookBuilder
public EventWorkbookBuilder()
createStubWorkbook
public static InternalWorkbook createStubWorkbook(ExternSheetRecord[] externs,
BoundSheetRecord[] bounds,
SSTRecord sst)
- Creates a stub Workbook from the supplied records,
suitable for use with the
HSSFFormulaParser
- 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 the
HSSFFormulaParser
- Parameters:
externs - The ExternSheetRecords in your filebounds - The BoundSheetRecords in your file
- Returns:
- A stub Workbook suitable for use with
HSSFFormulaParser