Php is 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, import the database data to excel to generate excel. of course, phpExcel class library is used, but it is too troublesome. it is not worth it 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.
The code is as follows:
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.
Of course, pipeline uses the phpExcel class library, but it is too troublesome. it is not worthwhile for simple generation, just import the database data to excel...