dovetail.com Forum Index dovetail.com
Knowledge Base / Support Forum
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Writing an excel file on z/OS

 
Post new topic   Reply to topic    dovetail.com Forum Index -> Open Source Java on z/OS
View previous topic :: View next topic  
Author Message
joel



Joined: 11 May 2009
Posts: 1

PostPosted: Mon May 11, 2009 4:43 pm    Post subject: Writing an excel file on z/OS Reply with quote

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?
Back to top
View user's profile Send private message
dovetail
Site Admin


Joined: 29 Jul 2004
Posts: 878

PostPosted: Mon May 11, 2009 5:08 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail
zlatan24



Joined: 02 Jul 2009
Posts: 1

PostPosted: Thu Jul 02, 2009 1:12 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    dovetail.com Forum Index -> Open Source Java on z/OS All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group