将数据导出到Excel,显示下载PHP的数据

发布于 2025-02-02 20:45:02 字数 2146 浏览 4 评论 0原文

我有代码

<?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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文