PhpSpreadsheet

最新推荐文章于 2025-06-03 09:01:46 发布

weixin_33853827

最新推荐文章于 2025-06-03 09:01:46 发布

阅读量754

点赞数

CC 4.0 BY-SA版权

文章标签： python

原文链接：https://my.oschina.net/u/3371661/blog/3048130

本文介绍如何使用PHPSpreadsheet库创建并导出Excel文件。通过实例展示了如何设置表头，填充单元格内容，以及如何将文件保存为.xlsx格式进行下载。此方法适用于批量数据的导出场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

"require-dev": {
     "phpoffice/phpspreadsheet": "^1.6"
},

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\IOFactory;

$spreadsheet = new Spreadsheet();
$worksheet = $spreadsheet->getActiveSheet();
$worksheet->setTitle('工作表格1');

$spreadsheet->getActiveSheet()->setTitle('Hello');
//表头
$k = 1;
$worksheet->setCellValue('A'.$k, '业务类型');
$worksheet->setCellValue('B'.$k, '商品总价');
$worksheet->setCellValue('C'.$k, '被推荐费');
$worksheet->setCellValue('D'.$k, '推荐费');
$worksheet->setCellValue('E'.$k, '成本费');
$worksheet->setCellValue('F'.$k, '商家应得');

//设置单元格内容
if($order){



    $k = 2; //从第二行开始
    foreach ($order as $key =>$val) {

        $worksheet->setCellValue('A'.$k, $val['pl_alias']);
        $worksheet->setCellValue('B'.$k, $val['price_total']);
        $worksheet->setCellValue('C'.$k, $val['be_recNum']);
        $worksheet->setCellValue('D'.$k, $val['be_recNum']);
        $worksheet->setCellValue('E'.$k, $val['recNum']);
        $worksheet->setCellValue('F'.$k, $val['deserved']);
        $k++;

    }
}





$fileName = '每日收益--'.$get['start_time'].'.xlsx';


header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="'.$fileName.'"');
header('Cache-Control: max-age=0');


$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('php://output');

转载于:https://my.oschina.net/u/3371661/blog/3048130