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?
Writing an excel file on z/OS
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.
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.
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.