views:

90

answers:

2

Apparently Excel 4.0 is still used and I have to read it in Java.

Neither poi nor jExcelAPI, as great as they are, can parse them. I can't find anything on them, especially with Java. Any help? Thank you.

+2  A: 

Have a look at JODconverter, which uses OpenOffice, where the list of support documents includes MS Excel 4.

If you can't use it directly, maybe you can convert to an intermediate format that works for you.

Stu Thompson
Man, I wish I'd known about this when I had to implement code that turned MS Office files into PDF and HTML; I wound up using the OpenOffice Java API directly, which isn't pleasant. But it definitely gets the job done.
BlairHippo
+1  A: 

If I recall correctly, Excel 4 had good support for reading and writing via DDE. If you're going way back, you might as well go waaaay back. I haven't used any myself, but Google shows several listings for Java DDE support. If nothing better pops up, you might give it a try.

John M Gant