A simple way to generate excel files in php_PHP tutorial

Of course, the phpExcel class library is used to generate excel, but it is too troublesome and not worth it for simple generation

What is simplicity? Just import the data from the database into excel. This is simplicity.

Look at a piece of code below (the code comes from the Internet)

Pay attention to the double-quoted string

Copy the code Code As follows:

header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=test.xls ");
echo "test1t";
echo "test2tn";
echo "test1t";
echo "test2tn";
echo "test1t";
echo "test2tn" ;
echo "test1t";
echo "test2tn";
echo "test1t";
echo "test2tn";
echo "test1t";
echo "test2tn";
?>

When you run it, the file test.xls will be downloaded. After opening, it will look like this

http://www.bkjia.com/PHPjc/730054.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/730054.htmlTechArticleGenerate excel. Of course, I use the phpExcel class library, but it is too troublesome. For simple generation, It’s not worth it. What is simplicity? Just import the database data into excel...