Hi Mark, In Excel you can run web queries that connect to your server and load-up the data. How is the data originally stored, is it in a database? I think you can write a script to get your data and put this in a file then you can use webdrive to to create a network drive and connect to this and link it to excel. It all depends what the dat is needed for! -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Mark Langkau Sent: 13 July 2001 18:32 To: zope@zope.org Subject: [Zope] Export to Excel format?? Hi, I have a need to have data returned from a query to be displayed in either html, ascii, or MS-Excel formats. Before submitting a query, the user chooses if they want the result returned as a rendered html page to view, an ASCII file to download and import into something else, or as an Excel spreadsheet to download. (From the customers request. They haven't defined what "ascii' means yet - fixed length or csv). Any ideas on how to do this (export to Excel)? I don't think I'll need anything fancy, such as formulas, cell formatting, etc. Probably just a conversion of the html table into something that will be recognized and loaded by Excel. (Would a csv file named "something.xls" or even "something.csv" work??) I've searched the mailing list, but only found discussions on importing from Excel to Zope. I need to go the other way. Thanks, Mark _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )