1、安装
composer require phpoffice/phpspreadsheet
2、
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Border;
use PhpOffice\PhpSpreadsheet\Style\Font;
use PhpOffice\PhpSpreadsheet\Style\Color;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\IOFactory;
3、数据库导出到excel表中
//导出测试
public function daochu()
{
$spreadsheet = new Spreadsheet();
$worksheet = $spreadsheet->getActiveSheet();
//设置工作表标题名称
$worksheet->setTitle('车型品牌');
//表头
//设置单元格内容
$worksheet->setCellValueByColumnAndRow(1, 1, '车型品牌表');
$worksheet->setCellValueByColumnAndRow(1, 2, 'ID');
$worksheet->setCellValueByColumnAndRow(2, 2, '品牌名');
$worksheet->setCellValueByColumnAndRow(3, 2, '图片');
$worksh