Does anyone have any tips or pointers for reading in large excel files? I expect to be working with files over 100megs... as far as I can tell, even after registering a listener, POI reads the entire file before disposing of it, which equals heap space errors for me. Do methods exist for parsing each line of an excel doc as poi reads it in from the stream, getting access to those cell objects, and then allowing the objects to be garbage collected as I move on to the next row of cells?
Thanks in advance for your advice! Charles Harvey Charles Harvey Sr. Programmer Analyst ISC-AIT 215.898.4773
