Walter:
One question that sort of bothers me on this given your request what
program runs on Z/os that can read (and create the graphs) that the
XLS file contains?
It would seem to me that a simple .csv file could be created quite
easily on Z/os and then sent to the appropriate platform for the to
add the appropriate formula.
Ed
Ed
On Sep 17, 2012, at 4:09 AM, Walter Marguccio wrote:
From: "McKown, John" <[email protected]>
Supposedly, but I haven't actually tried. Look at:
http://poi.apache.org/
as always, thanks to everybody for your valuable input.
I'll try to answer to some of the questions which have been posed :
we don't have SAS, nor DB2;
.csv is considered not acceptable because it lacks features
which .xls offers (formatting, graphs, and so on)
CPAN is worth a try, thanks to John for explaining why it might NOT
work on z/OS. We don't have C compiler, either.
Radoslaw's comment about creating .xls on z/OS and not on a PC is
surely correct, I forgot that we
already offload some processes to distributed machines, depending
on the process.
As an example, if we need to produce a single .pdf file, we use
TXT2PDF on z/OS, pure. But if we need to produce
3,000 .pdf files, we offlload TXT2PDF's execution on a Linux box.
Likewise, we can think of producing the raw data
on z/OS, offloading the creation of a .xls on a Linux box, where
the availability of programs to create Excels is wider.
Sam, may I try your Cobol/assembler API ?
Walter Marguccio
z/OS Systems Programmer
BELENUS LOB Informatic GmbH
Munich - Germany
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
