[Zope] Export to Excel format??

Mark Langkau mark.langkau@pbmplus.com
Fri, 13 Jul 2001 12:32:07 -0500


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