Fair enough, thanks. -Brook
> -----Original Message----- > From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 16, 2003 10:07 AM > To: POI Users List > Subject: Re: event model vs iterating over rows > > > Generally if the data structures YOU choose are efficient, > the event model > will be faster/more memory efficient. > > On 7/16/03 9:34 AM, "Brook Stevens" <[EMAIL PROTECTED]> wrote: > > > Okay, so given this is it still better to use the event model or is > > iterating over the rows going to be better preformance > wise, or is it a > > ratio based on the file size? > > > > Thanks, > > Brook > > > >> -----Original Message----- > >> From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] > >> Sent: Tuesday, July 15, 2003 9:46 PM > >> To: POI Users List > >> Subject: Re: event model vs iterating over rows > >> > >> > >> The rows are returned in the order in which they are in the > >> file. There is > >> NOTHING to guarantee that the row records will be before the > >> cell records, > >> group the cell records, etc. You must just process cell and > >> row records > >> wherever they pop up independently as any order is valid. > >> You could make > >> some assumptions that would work "most of the time" but > its not the 90 > >> sheets you read that people remember, its the 10 you don't. > >> > >> For CSV, you'll probably need to add cells to some kind of > >> data structure. > >> Basically a 2 dimensional array or List of some kind then > iterate over > >> supposing you wish to use the event model. > >> > >> -Andy > >> > >> On 7/15/03 6:51 PM, "Brook Stevens" <[EMAIL PROTECTED]> wrote: > >> > >>> I am new to POI so please excuse me if this is a stupid question. > >>> > >>> I am trying to write a very simple excel reader that > >> essentially will > >>> process information row by row, and could be potentially > >> large files. The > >>> way I would do this with a csv file (which is what I am > >> replacing) is to > >>> simply read in each row. I looked at the example on > >> Javaworld which seems > >>> to do this, but mentions that the event model is better, > >> fine so now I am > >>> looking at using the event model. My issue is that I don't really > >>> understand if with the event model everything is in the > >> order that I expect > >>> it to be... i.e. if the last record was in row 2 and the > record I am > >>> processing now is in row 3 will there be any subsequent > >> records in row 2. > >>> Or do I need to read in the entire file before I am > >> positive that I have > >>> everything in row 2. And if that is the case would it just > >> be better to > >>> iterate over the rows. > >>> Hope I am making some sense, thanks. > >>> > >>> Brook > >>> > >> > >> -- > >> Andrew C. Oliver > >> http://www.superlinksoftware.com/poi.jsp > >> Custom enhancements and Commercial Implementation for Jakarta POI > >> > >> http://jakarta.apache.org/poi > >> For Java and Excel, Got POI? > >> > >> > >> > --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > > > > -- > Andrew C. Oliver > http://www.superlinksoftware.com/poi.jsp > Custom enhancements and Commercial Implementation for Jakarta POI > > http://jakarta.apache.org/poi > For Java and Excel, Got POI? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] >
