php导出excel文件

在项目根目录下使用composer安装
(composer工具如何使用？点击进入)
composer require phpoffice/phpspreadsheet:1.6.*
由于phpexcel不再维护，推荐使用phpspreadsheet

<?php
require '../vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$spreadsheet = new Spreadsheet();

$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World !');

$writer = new Xlsx($spreadsheet);
$writer->save('world.xlsx');

欢迎转载，转载请保留链接: https://www.phpzu.com/article/2020/03/21/960.html