将数据导出到Excel,显示下载PHP的数据
我有代码
<?php
$developersData= array(
array("NAME" => "John Doe", "EMAIL" => "[email protected]", "GENDER" => "Male", "COUNTRY" => "United States"),
array("NAME" => "Gary Riley", "EMAIL" => "[email protected]", "GENDER" => "Male", "COUNTRY" => "United Kingdom"),
array("NAME" => "Edward Siu", "EMAIL" => "[email protected]", "GENDER" => "Male", "COUNTRY" => "Switzerland"),
array("NAME" => "Betty Simons", "EMAIL" => "[email protected]", "GENDER" => "Female", "COUNTRY" => "Australia"),
array("NAME" => "Frances Lieberman", "EMAIL" => "[email protected]", "GENDER" => "Female", "COUNTRY" => "United Kingdom")
);
$fileName = "export_".date('Ymd') . ".xls";
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"$fileName\"");
$showColoumn = false;
if(!empty($developersData)) {
foreach($developersData as $developerInfo) {
if(!$showColoumn) {
echo implode("\t", array_keys($developerInfo)) . "\n";
$showColoumn = true;
}
echo implode("\t", array_values($developerInfo)) . "\n";
}
}
?>
工作正常之前的代码,但是现在它不使用浏览器
,仅显示数据未下载的数据,
我选择了参考表格 https://www.codexworld.com/export-data-data-to-to-to-excel-in-php/
I have code
<?php
$developersData= array(
array("NAME" => "John Doe", "EMAIL" => "[email protected]", "GENDER" => "Male", "COUNTRY" => "United States"),
array("NAME" => "Gary Riley", "EMAIL" => "[email protected]", "GENDER" => "Male", "COUNTRY" => "United Kingdom"),
array("NAME" => "Edward Siu", "EMAIL" => "[email protected]", "GENDER" => "Male", "COUNTRY" => "Switzerland"),
array("NAME" => "Betty Simons", "EMAIL" => "[email protected]", "GENDER" => "Female", "COUNTRY" => "Australia"),
array("NAME" => "Frances Lieberman", "EMAIL" => "[email protected]", "GENDER" => "Female", "COUNTRY" => "United Kingdom")
);
$fileName = "export_".date('Ymd') . ".xls";
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"$fileName\"");
$showColoumn = false;
if(!empty($developersData)) {
foreach($developersData as $developerInfo) {
if(!$showColoumn) {
echo implode("\t", array_keys($developerInfo)) . "\n";
$showColoumn = true;
}
echo implode("\t", array_values($developerInfo)) . "\n";
}
}
?>
before it was working fine but now its not working with browser
its showing only data not getting file downloaded
i have taken reference form https://www.codexworld.com/export-data-to-excel-in-php/
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论