Is anyone importing MS Excel files into Zope?
I am looking for a true XLS to ZODB type solution...(python) without asking users to resave their XLS spreadsheets into CSV(comma delimited) files for Zope to parse. TIA, -Trevor
Trevor Toenjes wrote:
I am looking for a true XLS to ZODB type solution...(python) without asking users to resave their XLS spreadsheets into CSV(comma delimited) files for Zope to parse.
Perhaps this might be of interest: http://www.xlhtml.org/ (seems to be down atm) converts xls -> html/xml/csv Worked for all (not too complicated) testcases I tried. hth, oliver
I am looking for a true XLS to ZODB type solution...(python) without asking users to resave their XLS spreadsheets into CSV(comma delimited) files for Zope to parse.
I've got code that uses Office2K as a COM object. It currently converts xls to html, but you could change that to whatever you want. Obviously, it requires Office2K, which obviously requires win32. To get around this, I call the methods over xmlrpc from a *nix box if required. You can have a look if it would be helpful. tim
Trevor Toenjes writes:
I am looking for a true XLS to ZODB type solution...(python) without asking users to resave their XLS spreadsheets into CSV(comma delimited) files for Zope to parse. Maybe "Kaivo Document Library"?
Dieter
participants (4)
-
Dieter Maurer -
Oliver Bleutgen -
Tim Hicks -
Trevor Toenjes