On 4/13/2010 2:00 PM, Murthy Andavolu wrote:
I am evaluating POI 3.6 and had this question: If I want to read in an Excel
2007 data file with about 15,000 rows, will POI 3.6 impose any limitations
on how many rows I can read in? Does it read the whole file into memory or
does it read the file piece by piece?
Thanks,
Murthy
Murthy,
Here's my $0.02 (or Euros)...
These days 15,000 rows is no big deal. As you probably know, Excel 2007
files are really XML and there are two ways they are handled
programmatically:
- With DOM (the whole tree is read in memory; less efficient, but
easier to program)
- With SAX (event oriented, you code is hooked (callback) and executed
only when needed; efficient, but harder to program)
The real question for large files is whether the user has some way of
specifying to POI: "I want SAX with my files". Motivated by your post
and out of curiosity I did the following. I renamed all the POI jar
files, adding the *.zip extension at the end, and then I did a search
(with the Windows search utility), looking for the word "SAX".
I got a lot of hits.
-Ramon
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
