PHP 原生导出 Excel文件

1.导出文件

    //连接数据库
    $link = mysqli_connect('127.0.0.1','root','root','数据库名称');
    //设置字符集
	mysqli_query($link,'set articles utf_8');
    //sql语句
	$sql = "select * from articles";
    //执行sql语句
	$array = mysqli_query($link,$sql);
	$arr = [];
    //循环转化为数组
	while ($list = mysqli_fetch_assoc($array)) {
		$arr[] = $list;
	}
    //数据拼接
	$newArr ="ID\t标题\t副标题\t作者\t内容\n";
	foreach ($arr as $item){
		$newArr .= $item['id']."\t".$item['title']."\t".$item['titleF']."\t".$item['name']."\t".$item['content']."\n";
	}

	header('Content-type: application/excel');
	header('Content-Disposition: attachment; filename="daochu.xlsx"');
    //输出后会自动下载文件
	echo $newArr;