[Zope] Export to Excel format??

Oliver Bleutgen Oliver Bleutgen <myzope@gmx.net>
Fri, 13 Jul 2001 21:07:02 +0200


> 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.

Take a look at the thread beginning at
http://zope.nipltd.com/public/lists/zope-archive.nsf/ByKey/ADBCE79BD296A2C9

it should answer your question.

cheers,
oliver