aspose file tools*
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
Author

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: http://aspose.com/file-tools
 
subject: Help needed with POI
 
Similar Threads
use Apache POI to read Excel file problem
Read Excel Sheet Using Java
Uploading Excel spreadsheet into JSP
How tochange the values in an existing Excel file by using POI?
java program for pdf file to excel file conversion