• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Creating Excel File - POI

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic