php_XLSXWriter导出

Casual_1573

已于 2023-09-12 09:16:16 修改

阅读量291

点赞数

文章标签： php excel

于 2023-09-08 17:46:35 首次发布

本文链接：https://blog.youkuaiyun.com/qq_36345633/article/details/132765081

版权

<?php
include 'xlsxwriter.class.php';

$filename = "example.xlsx";
header('Content-disposition: attachment; filename="'.XLSXWriter::sanitize_filename($filename).'"');
header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
header('Content-Transfer-Encoding: binary');
header('Cache-Control: must-revalidate');
header('Pragma: public');

$rows = array(
    array('姓名', '年龄', '城市'),
    array('John', 25, 'New York'),
    array('Jane', 30, 'London'),
);

$writer = new XLSXWriter();

//方法一
$writer->writeSheet($rows);

//方法二
foreach($rows as $row){
    $writer->writeSheetRow('Sheet1', $row);
}


$writer->writeToStdOut();