[Zope] Export to Excel format??

[Norman Khine]

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 )