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: 39548
    
  27
What, exactly, is the problem? What code are you using to create the file?


Ping & DNS - updated with new look and Ping home screen widget
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: 39548
    
  27
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: 39548
    
  27
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Creating Excel File - POI
 
Similar Threads
Help- how POI convert number cell to text?
Text file xls to Binary format xls in Java.
Opening an Excel file
using forward slash in jsp to excel
generate large XLS file using java