Results 1 to 3 of 3
Thread: jExcell API question
- 02-09-2012, 07:19 PM #1
Member
- Join Date
- Feb 2012
- Posts
- 10
- Rep Power
- 0
jExcell API question
Hello, im trying to read an excell doc, but im having a problem, my method is just my incursion into the world reading-writting excell files, the problem is, it throws an exception (jxl.read.biff.BiffException: Unable to recognize OLE stream), when i tryo to open it with .ods format, so i tought "it migh be cause it only opens xls files" probably a not too analytic tought, but im quite new, so i changed the format of the archive to xls, and it trhow another kind of exception (java.lang.StringIndexOutOfBoundsException: String index out of range: 78). I even change the extension to xlsx for some data i read about old versions of the jxl that expect 4 characters on the extension, so out of bounds kinda had a reason, anyways, i realized that if i tryied with smal excell archives, like 1 sheet and few columns and rows, it just work... even if it is ods, but for some reason the excell archives i want to open throw exceptions, it is kinda big archive, 11 sheets and over 100 cols and rows. I leave the code of the method, even if it is no necessary, is pretty generic. Any idea of whats goin on any recommendation?
- 02-10-2012, 10:23 AM #2
Moderator
- Join Date
- Apr 2009
- Posts
- 10,438
- Rep Power
- 16
Re: jExcell API question
You'll need to show the actual stack traces, and the relevant code.
Googling the second one give this over at JBoss.
You must have saved it as a really old version (or Open Office has a mistake in it somewhere).
As for the first one, that usually implies you are trying to import a version of Excel that it doesn't support.
- 02-10-2012, 05:33 PM #3
Member
- Join Date
- Feb 2012
- Posts
- 10
- Rep Power
- 0
Re: jExcell API question
well thanks, i think youre right, i googled the exception aswell before posting here but it actually didnt helped me a lot... anyways what i tryied now, was copying the original excell file from my manager's PC, he made the spreadsheets design on excell, since his computer is the only one wich have excell and then imported it to open office so everyone could see it, and it actually oppened the document and read it, but still trhows a bunch of warnings... i think it is all about compatibility between the "spreadsheets editors" and the jxl Apis... anyone knows if POI, from apache, doesen't have the same issues?
Similar Threads
-
Java Question [Beginner Question]
By joker760 in forum New To JavaReplies: 3Last Post: 12-13-2011, 04:01 PM -
question posted by indissa: library question.
By Fubarable in forum New To JavaReplies: 2Last Post: 11-18-2011, 01:14 AM -
Question concerning question marks and colons
By jim01 in forum New To JavaReplies: 17Last Post: 01-14-2011, 12:05 AM -
Question mark colon operator question
By orchid in forum Advanced JavaReplies: 9Last Post: 12-19-2010, 08:49 AM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks