Re: [Zope] is it possible to import from Excel

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