File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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
jQuery in Action, 3rd edition