This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android 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
Similar Threads
How tochange the values in an existing Excel file by using POI?
Read Excel Sheet Using Java
java program for pdf file to excel file conversion
Uploading Excel spreadsheet into JSP
use Apache POI to read Excel file problem