Results 1 to 3 of 3
  1. #1
    GermánS is offline Member
    Join Date
    Feb 2012
    Posts
    10
    Rep Power
    0

    Default 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?
    Attached Files Attached Files

  2. #2
    Tolls is online now Moderator
    Join Date
    Apr 2009
    Posts
    11,947
    Rep Power
    19

    Default 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.

  3. #3
    GermánS is offline Member
    Join Date
    Feb 2012
    Posts
    10
    Rep Power
    0

    Default 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

  1. Java Question [Beginner Question]
    By joker760 in forum New To Java
    Replies: 3
    Last Post: 12-13-2011, 04:01 PM
  2. question posted by indissa: library question.
    By Fubarable in forum New To Java
    Replies: 2
    Last Post: 11-18-2011, 01:14 AM
  3. Question concerning question marks and colons
    By jim01 in forum New To Java
    Replies: 17
    Last Post: 01-14-2011, 12:05 AM
  4. Question mark colon operator question
    By orchid in forum Advanced Java
    Replies: 9
    Last Post: 12-19-2010, 08:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •