Version: 1.0
Type: Function
Category: Other
License: GNU General Public License
Description: Export your data to a csv and read with Excel
<?php /* * Export your array to csv * Created by Leo Watanabe <leow_74 at yahoo dot com> - August 2003 */ // Caution: $data MUST be an array of array function convertToExcelCSV($data) { // Sorry, not an array... if(!is_array($data)) { return ''; } $csv = ''; foreach($data as $record) { // all record must be an array if(is_array($record)) { // convert this record to csv $csv .= convertArrayToCSV($record) . "rn"; } } return $csv; } // convert an array to csv function convertArrayToCSV($record) { // need to test because I don't have privative functions :((( if(!is_array($record)) { return ''; } $ret = ''; foreach($record as $field) { if (is_array($field)) { // convert recusively $ret .= convertArrayToCSV($field); } else { // if field has double quotes or commas if (strpos($field,'"')!==false || strpos($field,',')!==false) { // replace " by "", and put all inside " // "all_field_value,_will_be_here" $ret .= '"' . str_replace('"','""',$field) . '"'; } else { $ret .= $field; } } // comma separated values $ret .= ','; } // strip last comma return substr($ret, 0, strlen($ret)-1); } ?>