reading excel files

[JÅns MÁrtin SchlÁttÅr]

I want to read a lot of excel files with java on a non-windows
machine.
I'm not sure about the excel-version used to write the files.
It is not possible to modify or export the excel files for this task.
I want to read the cell contents, nothing else. I'm not interested in
cell formatting or formulas.

I tried JXL, but it does not work because the excel file is write
protected.
But I can open and read it with OpenOffice.

Are there any other simple and free tools?

Martin

 

[Thomas Kellerer]

Jеns Mаrtin Schlаttеr wrote on 18.10.2008 23:04:

I want to read a lot of excel files with java on a non-windows
machine.
I'm not sure about the excel-version used to write the files.
It is not possible to modify or export the excel files for this task.
I want to read the cell contents, nothing else. I'm not interested in
cell formatting or formulas.

I tried JXL, but it does not work because the excel file is write
protected.
But I can open and read it with OpenOffice.

Are there any other simple and free tools?

http://poi.apache.org/

 

[JÅns MÁrtin SchlÁttÅr]

Are there any other simple and free tools?

http://poi.apache.org/

Is it simple and small?

 

[JÅns MÁrtin SchlÁttÅr]

Are there any other simple and free tools?

http://poi.apache.org/

=> HSSF does not currently support encrypted workbooks

Since I can open and read the excel sheet with OpenOffice without
using a password, I doubt that the workbook can be called encrypted!?

Martin