Re: Array to csv or excel in php

For non-simple data I have been using PEAR's File_CSV package. It's proven itself very useful in regards to not having to determine in my own code whether something needs to be quoted etc etc - especially if the output CSV needs to be wholly RFC 4180 compliant. The documentation of it is rather minimal - at the moment you are dependant on the test/example files and the API docs but grokking how to use it is rather easy. k. On Mon, Apr 19, 2010 at 4:40 PM, Andrew Ballard <aballard@gmail.com> wrote: > On Mon, Apr 19, 2010 at 11:14 AM, Peter Lind <peter.e.lind@gmail.com> wrote: >> On 19 April 2010 17:00, Andrew Ballard <aballard@gmail.com> wrote: >>> On Mon, Apr 19, 2010 at 9:45 AM, Manolis Vlachakis >>>>   1. $save=split("[|;]",$listOfItems); >>>> >>>> and what i want i s after making some changes to the attributes on the array >>>> above to export them on an csv or excel format >>>> but directly as a message to the browser .. >>>> i dont want it to be saved on the server ... >>>> >>> Often when outputting csv, I usually do something like this: >>> >>> <?php >>> >>> $fp = fopen('php://output', 'w') or die('Could not open >>> stream'); >>> >>> foreach ($data as $row) { >>>    // Assumes that $row will be an array. >>>    // Manipulate the data in $row if necessary. >>>    fputcsv($fp, $row); >>> } >>> >>> ?> >> >> An interesting idea. I'd do: >> >> echo implode(',', $row); >> > > If it's very simple data that works, but it doesn't allow for the > optional enclosure characters that fputcsv() uses in cases where a > data element includes the column and/or row delimiter characters. I > had originally written something using an array_map callback that did > the optional enclosures as needed and then used echo implode() as you > suggest, but found the solution I posted was shorter and faster. YMMV > > Andrew > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- http://blogs.linux.ie/kenguest/