[Zope] Re: CSV (Was: Perl scripts)

[Julian Melville]

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 )