Re: question: format an excel file (.xls) inside sqr program

[Brian Utter <butter@MCC.MIRACOSTA.CC.CA.US>]

Well, if you open the file in a text editor, you get this:  "00010" 00010
There is no comma in the file.

--
Brian Utter
Research Analyst
MiraCosta College
One Barnard Drive
Oceanside, Ca 92056
(760)795-6846

James Womeldorf wrote:

> Wonderful!
> Thanks for your help.
> If any of us discovers the way around this I assume we will let the others
> know.
>
> FYI, I get the same results with the attached csv file which I find even
> more disturbing.  I always felt that when all else fails you could always
> resort to csv.
>
> -----Original Message-----
> From: Fetzik, John [mailto:JFetzik@SANDC.COM]
> Sent: Monday, January 08, 2001 10:57 AM
> To: SQR-USERS@list.iex.net
> Subject: Re: question: format an excel file (.xls) inside sqr program
>
> Using Excel 97 SR-2 I get a single field with the string 00010 00010 in it.
> Sounds like Microsoft changed the defaults yet again with Office 2000.
>
> > -----Original Message-----
> > From: James Womeldorf [mailto:jwomeldo@FASTENAL.COM]
> > Sent: Monday, January 08, 2001 10:48 AM
> > To: SQR-USERS@list.iex.net
> > Subject: Re: question: format an excel file (.xls) inside sqr program
> >
> >
> > Unfortunately that doesn't work for me.  I am using Excel 2000 and am
> > beginning to wonder if this is a new 'feature' of that version.
> > Would someone else who is not on Excel 2000 try loading the
> > attached file?
> > When I load it I get 2 cells, both of which contain
> > 10
>
>   ------------------------------------------------------------------------
>
>    test.csvName: test.csv
>            Type: Microsoft Excel Comma Separated Values File 
>(application/x-unknown-content-type-Excel.CSV)

--
Brian Utter
Research Analyst
MiraCosta College
One Barnard Drive
Oceanside, Ca 92056
(760)795-6846