On Fri, 18 Oct 2002, Warnes, Gregory R wrote:
I regularly use a Perl script called from Zope to do the opposite conversion: *from* xls *to* csv. Initially, I used this code in an external python script, This is the way I decided to go now: Use an External Python Script to call a Perl Script in local file system. I've thought I misunderstood something in the documentation that I could Perl directly in an External Script without wrapping it in Python. (Perhaps the hint of Andy McKay will enlighten me once www.zope.org is available again ...)
but I've now created a Zope product called 'CSVFile' which checks the file extension and automatically converts uploaded files from xls to csv if required. Here is the appropriate code snippet: Thanks. I'll use this as an example.
As an aside, I use double-quotes to bracket each cells contents and comma separation. With this, I haven't had any problems here with MS-Excel failing to properly convert csv files when opening them -- with any of IE, Mozilla, Netscape 4 on W2K. I'll give this a further try. Did you also testet it under Linux with Gnumeric?
Kind regards Andreas.