I did this once by then tweaking an excel file to look right, and then
ftp'ing it back to the server as a template, then populating it with data
naming it *.xls.
Our greatest duty in this life is to help others. And please, if you can't
help them, could you at least not hurt them? - H.H.
Hi Dave,
One idea for you would be to use our FusionWare ADO.Net Provider, using
ASP.NET, write an application that calls FusionWare ADO.NET to execute a
basic program that returns the data. Then Create an instance of the
Excel Object and pump the data from the ADO.NET Dataset into the
From: Dave Tabor
I'd like to be able to create an excel file from a Unidata program
to be used for download on a website, without any user intervention.
Dan Fitzgerald wrote:
I did this once by then tweaking an excel file to look right, and
then ftp'ing it back to the server as a template,
If you want to try out various delimited formats (CSV, HTML, XML etc) you might
want to check out Download from Cedarville:
ftp.cedarville.edu/download
It's free and simple to use, though it doesn't specifically offer XLS as a
format. Otherwise you're into scripting Excel in some way.
Brian
Mr. Angliss:
It seems that there's been some namespace shuffling. To generate binary
excel files, use Spreadsheet::SimpleExcel, documented here:
http://cpan.uwinnipeg.ca/htdocs/Spreadsheet-SimpleExcel/Spreadsheet/SimpleExcel.html
For the new-fangled XML format that Microsoft is moving toward,