如何使用 php 生成.xlsx
2022-08-30 16:39:45
我需要生成一个扩展名为..xlsx
这是我的简单代码:
$file = "test.xlsx";
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename='.$file);
$content = "Col1\tCol2\tCol3\t\n";
$content .= "test1\ttest1\ttest3\t\n";
$content .= "testtest1\ttesttest2\ttesttest3\t\n";
echo $content;
但是当我打开生成的文件时,我收到此错误:
Excel cannot open the file 'test.xlsx' because the file format or file extension is not valid.
有什么想法吗?