Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Bear Bibeault
  • Liutauras Vilda
  • Devaka Cooray
Sheriffs:
  • Knute Snortum
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • salvin francis
  • Frits Walraven
  • Piet Souris

Creating Excel File - POI

 
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
 
Rancher
Posts: 43011
76
  • 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: 43011
76
  • 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: 43011
76
  • 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.
 
Looky! I'm being abducted by space aliens! Me and this tiny ad!
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!