PHP generates Excel directly on the Web page to provide a way to download

In the PHP environment to run the above code, you can see the browser asks the user whether to download the Excel document, click Save, the hard disk on the more than one Excel file, using Excel Open will see the final result, how good it. In fact, when doing real applications, you can take the data out of the database, and then follow the end of each column to add \ t, after each line of data to add \ n method echo out, at the beginning of PHP with the header ("content-type:application/ Vnd.ms-excel "), indicating that the output is an Excel file, with the header (" Content-disposition:filename=test.xls "), and that the output file name is Text.xls. This will be OK. Header ("Content-type:application/vnd.ms-excel"); Header ("Content-disposition:filename=test.xls"); echo "Test1\t"; echo "test2\t\n"; echo "Test1\t"; echo "test2\t\n"; echo "Test1\t"; echo "test2\t\n"; echo "Test1\t"; echo "test2\t\n"; echo "Test1\t"; echo "test2\t\n"; echo "Test1\t"; echo "test2\t\n"; ?> Copy Code

PHP, Excel

