Martin, I have no trouble with formulae in .csv, I do it all the time from Rexx on z/OS. I will generate two calculation cells like this, for instance:
"=IF(D2>0,(F2-D2),"" "")","=IF(D2>0,(H2/D2),"" "")", I found that I have to surround the formula with double quotes (because of the embedded spaces) and double any embedded double quotes for Excel to interpret the CSV formula correctly and generate the calculated result. The above cells look like this once the file is downloaded from z/OS to the PC and opened by Excel: =IF(D2>0,(F2-D2)," ") =IF(D2>0,(H2/D2)," ") HTH Peter -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Martin Packer Sent: Friday, September 14, 2012 5:09 PM To: [email protected] Subject: Re: Creating .xls on z/OS .CSV won't contain formulae. Don't know if that's what bothers the OP - but it bothers ME as I'd like to generate them in REXX. Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: [email protected] Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: "R.S." <[email protected]> To: [email protected], Date: 09/14/2012 08:23 PM Subject: Re: Creating .xls on z/OS Sent by: IBM Mainframe Discussion List <[email protected]> W dniu 2012-09-14 15:44, Walter Marguccio pisze: > Hello all, > > I've been asked if there is the possibility to create Excel tables (.xls) files on z/OS, > using a batch job. I've searched the archives, the developerwork IBM's site, redbooks, > but found no clue. > We run the XMITIP tool which is able to create .csv files, but this seems not enough. Just curious: why .CSV is not enough? What features do you expect? Drawings? -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
