Problem with JXL: unable to read GSEA xls file

[angeloulivieri]

Hi all,
I'm using JXL libraries to read some output file of a bioinformatics software called GSEA. These files are all written in a folder produced by the sw.
I've used the following code to read:

WorkbookSettings wsUp = new WorkbookSettings();
wsUp.setLocale(new Locale("en", "EN"));
Workbook workbookUp=null;
Sheet s = null;
workbookUp = Workbook.getWorkbook(ee.filesUp.get(i),wsUp);
s = workbookUp.getSheet(0);

But Eclipse can't open the file returning:
jxl.read.biff.BiffException: Unable to recognize OLE stream

And the computation is stopped on getWorkbook line

Someone knows when this error is present what I have to do on the excel file preliminarly?
Thanks

[j2me64]

Hi all,
I'm using JXL libraries to read some output file of a bioinformatics software called GSEA. These files are all written in a folder produced by the sw.
I've used the following code to read:

WorkbookSettings wsUp = new WorkbookSettings();
wsUp.setLocale(new Locale("en", "EN"));
Workbook workbookUp=null;
Sheet s = null;
workbookUp = Workbook.getWorkbook(ee.filesUp.get(i),wsUp);
s = workbookUp.getSheet(0);

But Eclipse can't open the file returning:
jxl.read.biff.BiffException: Unable to recognize OLE stream

And the computation is stopped on getWorkbook line

Someone knows when this error is present what I have to do on the excel file preliminarly?
Thanks

i don't know what ee.filesUp.get(i) returns, but try

File file = new File ("drive\\path\\yourfile.xls");
workbookUp = Workbook.getWorkbook(file, wsUp);

it would be easier if you post all your code. the reason for the BiffException could be, that the xls files has been written with an older version of excel 2003.

[angeloulivieri]

i don't know what ee.filesUp.get(i) returns, but try

File file = new File ("drive\\path\\yourfile.xls");
workbookUp = Workbook.getWorkbook(file, wsUp);

it would be easier if you post all your code. the reason for the BiffException could be, that the xls files has been written with an older version of excel 2003.

Sorry... the ee.filesUp.get(i) returns a File object and it works.
I found that the problem is with these files.
They are not excel files but csv files.
So, the question is... exists a method to read csv files with JXL?

[j2me64]

So, the question is... exists a method to read csv files with JXL?

looking at the jxl api i couldn't find any methods for reading csv files. but you can read csv files in java with the classes in java.io and then extract the values with a tokenizer and then build your workbook with jxl and put the readed values to the workbook.