<?php /* 
This example demonstrates 
how to convert PHP array data to MS Excel 2003 data to download <br>
user data base.
Here we create a simple HTML tabler data and we force the web browser as stream data
instead we simply displaying HTML table
thats all
 */
$data_headers=array('First Name','Last Name','Date of Birth');
$data_array[]=array('Mahesh','Chari','25-08-1983');
$data_array[]=array('Chari','Mahesh','25-08-1980');
$data_array[]=array('Guggilla','Mahesh','25-08-1970');
$data_array[]=array('Mahesh','Guggilla','21-08-1985');
$data_array[]=array('Mahesh Chari','Guggilla','20-08-1950');
$data_array[]=array('Chari','Guggilla','25-08-1950');
// here we prepare a simple HTML table string
$html_string='<table>';
$html_string.='<tr><td>'.implode('</td><td>',$data_headers).'</td></tr>';
	foreach($data_array as $k=>$v){
		$html_string.='<tr><td>'.implode('</td><td>',$v).'</td></tr>';
	}
$html_string.='</table>';
//make time dependent xls name that is always unique
$xlsfile = "excel_example".date("m-d-Y-hiA").".xls";
//stop the browser displaying the HTML table displaying
//force the browser to download as xcel document
//if you make comment below two lines as php comments ,you see a simple HTML table
header('Content-type: application/vnd.ms-excel');
header("Content-Disposition: attachment; filename=$xlsfile");
 
print  $html_string;?>

<?php 
/* 
This example demonstrates 
how to convert PHP array data to MS Excel 2003 data to download <br>
user data base.
Here we create a simple text format like CSV with a delimiter \t tab and new line delimiter for rows
thats all
 */
$data_headers=array('First Name','Last Name','Date of Birth');
$data_array[]=array('Mahesh','Chari','25-08-1983');
$data_array[]=array('Chari','Mahesh','25-08-1980');
$data_array[]=array('Guggilla','Mahesh','25-08-1970');
$data_array[]=array('Mahesh','Guggilla','21-08-1985');
$data_array[]=array('Mahesh Chari','Guggilla','20-08-1950');
$data_array[]=array('Chari','Guggilla','25-08-1950');
// here we prepare a simple  \t delimetered text format 
$delim_string='';
$delim_string.=implode("\t",$data_headers)."\n";
	foreach($data_array as $k=>$v){
	$delim_string.=implode("\t",$v)."\n";
	}
 
//make time dependent xls name that is always unique
$xlsfile = "excel_example".date("m-d-Y-hiA").".xls";
//stop the browser displaying the data as text
//force the browser to download as xcel document
header('Content-type: application/vnd.ms-excel');
header("Content-Disposition: attachment; filename=$xlsfile");
 
print $delim_string;
 
?>