Thanks a lot Andy. if( bof.getType() == bof.TYPE_WORKSHEET ) works great. no need for my ugly flag now/
Tom. On Tue, Jun 3, 2008 at 9:20 PM, Andy Chien <[EMAIL PROTECTED]> wrote: > 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
