[Zope] is it possible to import from Excel

Ayhan Ergul ergul@ccs.neu.edu
Thu, 28 Dec 2000 01:24:44 -0500 (EST)


When on a windows platform, I prefer to define an ODBC datasource on the
excel spreadsheet, write ZSQL method that selects the fields to be
imported, write a DTML method that iterates on returned records and call
another ZSQL method that writes into Gadfly.

You may need to handle None/Missing values to prevent from ending up in
gadfly as 'None' etc.

Ayhan