通过composer安装了phpoffice/phpspreadsheet库
composer require phpoffice/phpspreadsheet
实现代码块
<?php
namespace app\excel\controller;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use think\Controller;
class ExcelController extends Controller
{
public function exportExcel()
{
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setTitle('Sheet1');
$sheet->setCellValue('A1', 'ID');
$sheet->setCellValue('B1', '姓名');
$sheet->setCellValue('C1', '年龄');
$sheet->setCellValue('A2', 1);
$sheet->setCellValue('B2', '张三');
$sheet->setCellValue('C2', 25);
$sheet->getColumnDimension('A')->setWidth(10);
$sheet->getColumnDimension('B')->setWidth(20);
$sheet->getColumnDimension('C')->setWidth(15);
$sheet->getRowDimension(1)->setRowHeight(20);
$sheet->getRowDimension(2)->setRowHeight(30);
$writer = new Xlsx($spreadsheet);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="export.xlsx"');
header('Cache-Control: max-age=0');
$writer->save('php://output');
}
}