$_SESSION['report_values'][$i][8] = '"' . $row["manufacturer"] . '" '; $_SESSION['report_values'][$i][9] = '"' . $row["flag"] . '" '; $i++; } #### Roshan's very simple code to export data to excel #### Copyright reserved to Roshan Bhattarai - nepaliboy007@yahoo.com #### if you have any problem contact me at http://roshanbh.com.np #### fell free to visit my blog http://php-ajax-guru.blogspot.com //code to download the data of report in the excel format $fn = "export" . date("j l Y") . "." . "xls"; include_once "class.export_excel.php"; //create the instance of the exportexcel format $excel_obj = new ExportExcel("{$fn}"); //setting the values of the headers and data of the excel file //and these values comes from the other file which file shows the data $excel_obj->setHeadersAndValues($_SESSION['report_header'], $_SESSION['report_values']); //now generate the excel file with the data and headers set $excel_obj->GenerateExcelFile(); /* $a=$_SESSION['report_values']; $c=sizeof($a); for($j=0;$j<$c;$j++) { for($i=0;$i<10;$i++) { print_r($_SESSION['report_values'][$j][$i]." \t "); } print_r("\n"); } */ include '../closedb.php';