Nick Burch wrote: > > If memory serves correct, you need to keep track of the sheet start > records as they go past. All the cells for a given sheet go together, so > they'll belong to the most recent sheet you've seen > > If memory serves, you get an EOFRecord then a BOFRecord between each > sheet's data. (You get them in a few other places too, but if you get one > then a little while later some cells, it's one sheet, then another and > some cells is the next) >
quick thanks to nick and russ. i scanned the accessor methods (getters) of BOFRecord and EOFRecord as well as the excel field specification. EOFRecord and BOFRecord does helps differentiate between sheet but i cannot find a way to associate sheet name to the corresponding BOFRecord. BoundSheetRecord does have method that gets the BOFRecord offset, if i obtain the offset of each sheet, then sort the offset. can i safely assume that the BOFRecord i encountered would be in that sequential order as the sorted (ascending) offset? is this how i keep track of sheets in eventusermodel? my reading from poi sorce suggest this way it would work but i'd like some confirmation because this is a tiny bit different from the earlier proposal (which almost seems to suggest that metadata can be obtained from the BOF/EOFRecord). thanks. -- View this message in context: http://www.nabble.com/identify-excel-sheet-in-eventusermodel-tp16182268p16259943.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
