告别手动导出！如何使用liuggio/excelbundle与Composer轻松玩转SymfonyExcel文件

<code class="bash">composer require liuggio/excelbundle</code>

<pre class="brush:php;toolbar:false;">// config/bundles.php
return [
    // ...
    Liuggio\ExcelBundle\LiuggioExcelBundle::class => ['all' => true],
];

<pre class="brush:php;toolbar:false;">// 在你的Controller中
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\HttpFoundation\ResponseHeaderBag;

class ReportController extends AbstractController
{
    public function exportAction(): Response
    {
        // 获取 phpexcel 服务
        $phpExcelObject = $this->get('phpexcel')->createPHPExcelObject();

        // 设置文档属性
        $phpExcelObject->getProperties()->setCreator("Your Name")
            ->setLastModifiedBy("Your Name")
            ->setTitle("Sales Report")
            ->setSubject("Sales Report")
            ->setDescription("Generated sales report.")
            ->setKeywords("sales report excel");

        // 设置第一个工作表
        $phpExcelObject->setActiveSheetIndex(0)
            ->setCellValue('A1', 'Hello')
            ->setCellValue('B2', 'World!');
        $phpExcelObject->getActiveSheet()->setTitle('My Sheet');

        // 设置活动工作表索引，确保Excel打开时显示第一个工作表
        $phpExcelObject->setActiveSheetIndex(0);

        // 创建写入器，这里选择 Excel5 (老版 .xls 格式)
        $writer = $this->get('phpexcel')->createWriter($phpExcelObject, 'Excel5');

        // 创建流式响应，直接将文件发送到浏览器
        $response = $this->get('phpexcel')->createStreamedResponse($writer);

        // 添加响应头，告诉浏览器这是一个文件下载
        $dispositionHeader = $response->headers->makeDisposition(
            ResponseHeaderBag::DISPOSITION_ATTACHMENT,
            'sales_report.xls'
        );
        $response->headers->set('Content-Type', 'text/vnd.ms-excel; charset=utf-8');
        $response->headers->set('Pragma', 'public');
        $response->headers->set('Cache-Control', 'maxage=1');
        $response->headers->set('Content-Disposition', $dispositionHeader);

        return $response;
    }
}

<pre class="brush:php;toolbar:false;">// 假设你的文件在 web/uploads/template.xls
$filePath = $this->getParameter('kernel.project_dir') . '/public/uploads/template.xls';
$phpExcelObject = $this->get('phpexcel')->createPHPExcelObject($filePath);

// 之后你可以像上面那样修改它并导出

<pre class="brush:php;toolbar:false;">// ...
$writer = $this->get('phpexcel')->createWriter($phpExcelObject, 'Excel2007');
// ...
$dispositionHeader = $response->headers->makeDisposition(
    ResponseHeaderBag::DISPOSITION_ATTACHMENT,
    'sales_report.xlsx'
);
$response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=utf-8');
// ...

<pre class="brush:php;toolbar:false;">// ...
$drawingobject = $this->get('phpexcel')->createPHPExcelWorksheetDrawing();
$drawingobject->setName('Company Logo');
$drawingobject->setDescription('My Company Logo');
$drawingobject->setPath('/path/to/your/logo.png'); // 替换为你的图片路径
$drawingobject->setHeight(60);
$drawingobject->setOffsetY(20);
$drawingobject->setCoordinates('A1'); // 图片放置的单元格
$drawingobject->setWorksheet($phpExcelObject->getActiveSheet());
// ...