File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help needed with POI

 
Nigel Browne
Ranch Hand
Pie
Posts: 682
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic