aspose file tools*
The moose likes Other Open Source Projects and the fly likes Creating Excel File - POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Creating Excel File - POI" Watch "Creating Excel File - POI" New topic
Author

Creating Excel File - POI

Abid Hasnain
Greenhorn

Joined: Apr 09, 2011
Posts: 3
Hi,

I am having problem with the version of .xls file that is generated using POI API. the program that I have to provide an .xls file requires Ms excel format of "Microsoft Excel 5.0/95 Workbook".

How can I save the file in this format.

Regards,
Abid Hasnain
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42648
    
  65
What, exactly, is the problem? What code are you using to create the file?


Ping & DNS - my free Android networking tools app
Abid Hasnain
Greenhorn

Joined: Apr 09, 2011
Posts: 3


This is a simple code. Now the excel created through this code is an excel version that cannot be read by a third party application that is using my excel file. This application requires an excel file that is a Ms excel version "Microsoft Excel 5.0/95 Workbook".

So I want to know how can i save the workbook file in this format.

Thanks,
Abid Hasnain
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42648
    
  65
You may be out of luck. From the HSSF page: HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. - which is probably not readable by an app that only understands Excel 5.0/95.
Abid Hasnain
Greenhorn

Joined: Apr 09, 2011
Posts: 3
Thankyou for you reply. Is there any other API that I can use which can construct the above required excel format.

Thanks,
Abid Hasnain
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42648
    
  65
Not to my knowledge. The other major Java Excel API -jExcelApi- also creates Excel 97 files (as I'm sure you've found out by now on its web site).

You might be able to use OpenOffice through its Java API; I'm not sure if it supports that particular file format, though, but its documentation would tell you quickly.
 
Consider Paul's rocket mass heater.
 
subject: Creating Excel File - POI