代码之家 › 专栏 › 技术社区 › Genarito

在下载phpspreadsheet文件之前不保存它

phpspreadsheet symfony4 php-7

5

Genarito · 技术社区 · 8 年前

我在用 PhpSpreadsheet 在symfony 4中生成一个excel文件。我的代码是:

$spreadsheet = $this->generateExcel($content);

$writer = new Xlsx($spreadsheet);
$filename = "myFile.xlsx";
$writer->save($filename); // LINE I WANT TO AVOID
$response = new BinaryFileResponse($filename);
$response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
$response->setContentDisposition(
    ResponseHeaderBag::DISPOSITION_ATTACHMENT,
    $filename
);

但我不想保存文件,然后读取它返回给用户。我想直接下载excel内容。有办法吗?

我已经搜索了如何生成内容流(如 this answer 但是我没有成功。

提前谢谢,对不起我的英语

1 回复 | 直到 8 年前

1

14

pumpkinthehead 7 年前

据我所知,您正在生成代码中的内容。你可以 stream the response in Symfony 并将phpspreadsheet writer配置为保存到“php://output”(参见此处的官方文档 Redirect output to a client's web browser )

下面是一个使用symfony 4.1和phpspreadsheet 1.3的工作示例:

<?php

namespace App\Controller;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use Symfony\Component\HttpFoundation\StreamedResponse;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use PhpOffice\PhpSpreadsheet\Writer as Writer;

class TestController extends Controller
{


    /**
     * @Route("/save")
     */
    public function index()
    {

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

        $writer = new Writer\Xls($spreadsheet);

        $response =  new StreamedResponse(
            function () use ($writer) {
                $writer->save('php://output');
            }
        );
        $response->headers->set('Content-Type', 'application/vnd.ms-excel');
        $response->headers->set('Content-Disposition', 'attachment;filename="ExportScan.xls"');
        $response->headers->set('Cache-Control','max-age=0');
        return $response;
    }
}