Page 1 of 1

Writing an excel file on z/OS

Posted: Mon May 11, 2009 4:43 pm
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?

Posted: Mon May 11, 2009 5:08 pm
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.

Posted: Thu Jul 02, 2009 1:12 am
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.