Php: a simple way to generate an excel file

Of course, the phpExcel class library is used to generate an excel file, but it is too troublesome. it is not worthwhile for simple generation.

What is simple? Just import the database data to excel. This is simple.

See the following code (the Code comes from the network)

Note the double quotation mark string.
Copy codeThe Code is as follows:
<? Php
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 ";
?>

The file test.xls will be downloaded at runtime. It will be like this when it is opened.