• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Creating Excel File - POI

 
Abid Hasnain
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What, exactly, is the problem? What code are you using to create the file?
 
Abid Hasnain
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic