Changing my filename suffix from csv to xls actually made things worse. From mozilla I have the same behavior: The file opens in excel but columns are not split. From IE I have new behavior: IE only asks once (instead of twice) to open file, but now excel does not split columns. It might have something to do with the excel version (I'm using 2k). It's also possible that I need to wrap each field in quotes but at this point I'm getting fed up.
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Tino Wildenhain Sent: Wednesday, October 16, 2002 10:54 AM To: Andreas Tille; Zope user list Subject: Re: [Zope] Re: CSV (Was: Perl scripts)
Hi Andres,
just to make sure - try to name your script to filename.xls
this works at least for us here.
Regards Tino
--On Mittwoch, 16. Oktober 2002 17:08 +0200 Andreas Tille <tillea@rki.de> wrote:
On Wed, 16 Oct 2002, Tino Wildenhain wrote:
for the buggy-as-hell Excel, the trick is to name the .csv File .xls Then Excel can split the columns correctly. I tried it with exactly the same example - without any success :-(. (Also Gnumeric shows one single column instead of three.)
Kind regards
Andreas.