generate an Excel file using PHP

php excel web-applications

PHP Snippet 1:

//define separator (defines columns in excel & tabs in word) 
$sep = "\t"; //tabbed character 
$fp = fopen('database.xls', "w"); 
$schema_insert = ""; 
$schema_insert_rows = ""; 
//start of printing column names as names of MySQL fields