Re: [PHP] Re: excel output question

2004-02-07 Thread Paul Furman
Jake McHenry wrote: That just filled my spreadsh**t with quotes around everything... still the amounts larger than 1k are in 2 columns.. did I do something wrong? Sorry it didn't work. Maybe double quotes? I've output data from MS Access that came out smothered in quotes and when importing t

Re: [PHP] Re: excel output question

2004-02-07 Thread Jake McHenry
- Original Message - From: "Phillip Jackson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 07, 2004 4:37 AM Subject: Re: [PHP] Re: excel output question > I would do it like this: > > $build = " '%s','%s'

Re: [PHP] Re: excel output question

2004-02-07 Thread Phillip Jackson
I would do it like this: $build = " '%s','%s','%s','%s'\n"; $build = sprintf($build,$field1,$field2,$field3,$fieldN); you could also try escaping the comma. if this doesn't work you can always just dump to html tables and save the file as *.xls (excel spreadsheet); excel understands html tables a

Re: [PHP] Re: excel output question

2004-02-07 Thread Jake McHenry
- Original Message - From: "Paul Furman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 07, 2004 1:56 AM Subject: [PHP] Re: excel output question > Single quote everything should work. > > Jake McHenry wrote: > > > Hi everyone. I'm outputing payroll information to a