php export to excel

php export to excel -export php array to excel

php export to excel -export php array to excel

Hi Friends i hope you are fine..in this lesson we will learn how to convert php array to excel and export as excel..this is beginners codes how oto export php file to excel..please use the below codes to php export to excel..

1. exportexcel.php

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46

<?php     $data = array(                array('Name'=>'CodeNair',                      'Age'=>'6 Months',                      'Category'=>'Web Design and Web Development'                      ),                array('Name'=>'CodeNair',                      'Age'=>'6 Months',                      'Category'=>'Web Design and Web Development'                      ),                     array('Name'=>'CodeNair',                      'Age'=>'6 Months',                      'Category'=>'Web Design and Web Development'                      )                                );     //Filter Function to FIlter Data     function filterData(&$str)     {         $str = preg_replace("/\t/", "\\t", $str);         $str = preg_replace("/\r?\n/", "\\n", $str);         if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';     }           //File Name     $fileName = "array_to_exel_codenair" . date('Ymd') . ".xls";           // headers for force download     header("Content-Disposition: attachment; filename=\"$fileName\"");     header("Content-Type: application/vnd.ms-excel");           $flag = false;     foreach($data as $row) {         if(!$flag) {             //Header Column             echo implode("\t", array_keys($row)) . "\n";             $flag = true;         }         //filtering data         array_walk($row, 'filterData');         echo implode("\t", array_values($row)) . "\n";       }           exit; ?>

That's it Friends how to export php data as excel ..if you like this post please share with your friends..Thank You..