Writing an excel file on z/OS

Discussions regarding Open Source Java projects under z/OS (other than Tomcat)
Post Reply
joel
Posts: 1
Joined: Mon May 11, 2009 4:36 pm

Writing an excel file on z/OS

Post by joel »

Hi I am a newbie to Mainframes. I have a J2EE application (WebSphere) hosted on mainframe. There is a need to write an excel (.xls) file on the mainframe using Java. The file would be read and parsed by another Java thread.
How do I go about writing an excel file on the mainframe? Would JZOS help?
dovetail
Site Admin
Posts: 2022
Joined: Thu Jul 29, 2004 12:12 pm

Post by dovetail »

You should be able to use any pure-Java library that can create Excel files, such as:

http://jexcelapi.sourceforge.net/
http://poi.apache.org/

Normal Java z/OS porting considerations apply: if the code "assumes" that the default file.encoding is ASCII, then you may need to run the JVM with -Dfile.encoding=ISO8859-1.
zlatan24
Posts: 1
Joined: Thu Jul 02, 2009 1:11 am

Post by zlatan24 »

For solve problems with excel files there is-repair xlsx corrupt,it is free as far as I know and has many features,besides that utility helped me many times and I grateful for it,software can repair .xlsx even without touching your keyboard, just left click your mouse several times and all of your data will be recovered,automatically and attempts to repair xlsx corrupt, that was considered lost,recover maximum percents of your document manually, than the entire Excel workbook.
Post Reply