This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes Help needed with POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Help needed with POI" Watch "Help needed with POI" New topic

Help needed with POI

Nigel Browne
Ranch Hand

Joined: May 15, 2001
Posts: 673
I am currently running a few test to see if I can reuse some excel files which contain data, without having to design a proper database around them.
I wrote the following code, which attempts to read the number of sheets from an existing file.

The code compiles, but when I run the program I recieve the following warnings
[WARNING] Unknown Ptg 69 (105) //repeated four times
[WARNING] Unknown Ptg 11 (17) at cell (29,4) //repeated for a few different cells
[WARNING] Unknown Ptg 69 (105) at Cell (121,4) // The Ptg 69 warning again this time on a number of different cells. Then eventually I receive a
java.lang.OutOfMemoryError and the program exiting.

Sorry for the long winded build up to my questions. What are these Warnings, can I find any documentation on them ? How do I prevent them and is there a limit to the size of Excel file I can read ?
I agree. Here's the link:
subject: Help needed with POI
It's not a secret anymore!