<table border=1>
"Jake McHenry" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > ----- 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','%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 and simple markup as spreadsheet data. > > > > ie: > > > > <html> > > <table> > > <tr> > > <td>field1</td><td>field2</td><td>field3</td><td>field4</td> > > </tr> > > <tr> > > <td>value1</td><td>value2</td><td>value3</td><td>value4</td> > > </tr> > > </table> > > </html> > > > > > > ~phillip > > "Jake McHenry" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > ----- 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 an excel csv file, > > and > > > when anyone get's paid over 1k, the amount is split into two fields > > because > > > of the comma in the amount. Is there anyway I can tell excel that this > > > particular comma is not a deliminator? > > > > > > > > > > Thanks, > > > > > Jake > > > > > > > > -- > > > > PHP General Mailing List (http://www.php.net/) > > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > > like this? > > > > > > output = > > > > > > "'$fullname',,'$location',,'$regularhours','$vachours','$sickhours','$compho > > > > > > urs','$mischours','$wopyhours','$sefahours','$biweekly[0]','$adjustedtime',, > > > ,,,'$sub401k > > > ','$payrate','$gross5'\n"; > > > > > > That just filled my spreadshit with quotes around everything... still > the > > > amounts larger than 1k are in 2 columns...... > > > > > > did I do something wrong? > > > > > > Thanks, > > > Jake > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > This is in a simple while loop, data is coming from a mysql database. > Creating a seperate function would too time consuming changing all of the > existing code for what this page is doing. It orignally was in html form in > an xls file, but when the file was opened, there were no cell borders > anymore. If anyone can tell me how to turn on the cell boarders in an xls > html outputted file, that would also work. This is the only reason I went > back to a csv file. > > Thanks, > Jake > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
