This is a basic function that accepts an array of data and an array of field names (column headers), and spits out a file for download.\u00a0 The two types of files are Excel and CSV.<\/p>\n
The example is enclosed in a utility class that can contain a number of other functions, but you can just as easily use the function without the class wrapper.<\/p>\n
<?php\r\nclass My_Utility {\r\n function export_array_to_file($data, $field_names, $file_name = '', $file_type = 'EXCEL') {\r\n switch (strtoupper($file_type)) {\r\n case \"EXCEL\":\r\n header(\"Content-type: \".\"application\/x-msexcel\");\r\n $DELIMITER = \"\\t\";\r\n $file_ext = \"xls\";\r\n break;\r\n case \"CSV\":\r\n header(\"Content-type: \".\"text\/plain\");\r\n $DELIMITER = \",\";\r\n $file_ext = \"csv\";\r\n break;\r\n } \r\n \r\n if (empty($file_name)) {\r\n $file_name = \"my_download_\" . date('YmdHis') . \".\" . $file_ext;\r\n }\r\n else {\r\n $file_name .= '.' . $file_ext;\r\n }\r\n\r\n \/* Stream fputcsv to php output to send to the browser instead of saving as a file *\/\r\n header(\"content-disposition: attachment; filename=\".$file_name);\r\n $outfile = fopen('php:\/\/output', 'w');\r\n \r\n if (!is_array($field_names)) {\r\n $field_names = explode(',', $field_names);\r\n }\r\n \r\n fputcsv($outfile, $field_names, $DELIMITER);\r\n foreach($data as $row) {\r\n fputcsv($outfile, $row, $DELIMITER);\r\n }\r\n fclose($outfile);\r\n \r\n exit();\r\n }\r\n}<\/pre>\nIt’s worth noting that you shouldn’t name the first column “ID” if you are using the Excel format. This is because Excel thinks that text files starting with IDxxx are in SYLK Format, and it will not open correctly.<\/p>\n","protected":false},"excerpt":{"rendered":"