Hi All:
Assuming you are using EventModel. From experimentation with Nick's
instructions I find the following observation.
BoundSheetRecord will pass first, these records will contain the name of
the sheet in order that they will appear (by their BOFRecord). In excel
perspective it will be the leftmost tab to the rightmost tab.
Then you will run into BOFRecords these records indicate a beginning of
a collection of records (including charts macro... etc see API for full
details). The specific BOFRecord type you are interested (the ones that
indicate a collection of sheets) can be isolated by the following code.
case BOFRecord.sid:
BOFRecord bof = (BOFRecord) record;
if( bof.getType() == bof.TYPE_WORKSHEET )
...
API here
http://poi.apache.org/apidocs/org/apache/poi/hssf/record/BOFRecord.html
Hope this helps.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
