I don't know your full requirements, but what I've done in the past is simply create the .csv file and copy it over to a spot in the http server's (ZFS) directory. Then create an Excel spreadsheet that references the CSV by importing the data "From Web". Set up the data range to automatically refresh when the sheet is loaded. Then create all your graphs and formatted reporting (don't touch the imported range, just reference it) in the sheet and save it. The final sheet can even be hosted on the http server as well if you wish so you can simply have a link on an html page that downloads and opens the spreadsheet and pulls in the latest data from the .CSV file.
I use that for a few things where I wanted to generate some graphical reporting but didn't have the time to set up something more sophisticated. It's pretty quick and easy to do once you've done it a couple of times. If you need multiple versions, you could probably set up something using GDGs served via the MVSDS service and a macro to select what generation to read into the spreadsheet, but I haven't tried this. Scott Chapman On Mon, 17 Sep 2012 02:09:30 -0700, Walter Marguccio <[email protected]> wrote: .csv is considered not acceptable because it lacks features which .xls offers (formatting, graphs, and so on) ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
