I did a quick test here (Excel 2k) - when I named the file .xls I ran into the problem of Excel trying to access the document via WebDAV instead of plain HTTP (Office 2k probes for a WebDAV port when trying to open files over HTTP). You may be running into this? When I named the file .csv and set the mime-type to text/comma-separated-values it worked fine - I was prompted to open or save the file, but it opened in Excel and split the fields. It didn't matter whether the fields were quoted, but I didn't have a very complicated data set. Julian.
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Charlie Reiman Sent: Thursday, 17 October 2002 4:53 AM To: Tino Wildenhain; Andreas Tille; Zope user list Subject: RE: [Zope] Re: CSV (Was: Perl scripts)
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.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )