PHPExcel无法保存文件或下载文件。

Question

PHPExcel无法保存文件或下载文件。

15

我正在尝试编写一个PHP函数，将一些数据导出到Excel文件。问题在于，如果我将其保存到服务器上，它可以正常运行，但是如果我尝试使用php://output发送到浏览器，它就无法工作。甚至不会显示下载窗口。我已经得到了以下响应：

PK��a�B%��a��[Content_Types].xml͔]K�0��%��f� "�v��R��kX��׿�m��+��4�<�'��2�jgs6�,+��v��Sz��a��tr5^�=Bb�9+c��,��9��.T"�kXr/�J,��[.��`ck6�?h�\��,��ܠ}3�c�C+��9�-E��|c�j�BKPN�+�d��u��O1� o��Ba +��G�

头信息如下：

Response Headers
Cache-Control   no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Connection  Keep-Alive
Content-Disposition attachment;filename="Report.xlsx"
Content-Type    application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Date    Wed, 29 May 2013 10:08:10 GMT
Expires Thu, 19 Nov 1981 08:52:00 GMT
Keep-Alive  timeout=15, max=78
Last-Modified   Wed, 29 May 2013 10:08:11 GMT
Pragma  no-cache
Server  Apache/2.2.14 (Ubuntu)
Transfer-Encoding   chunked
X-Powered-By    PHP/5.3.2-1ubuntu4.19
Request Headers
Accept  */*
Accept-Encoding gzip, deflate
Accept-Language en-US,en;q=0.5
Cookie  PHPSESSID=075r4aaqrvcnbca5sshjvm0jq7; 87293ba76812d31889be0901b086dd73=5h4jriq5c7r9vdt3m2u2u9up43; d82d00149fafbe651c9ba75a9804bbc9=en-GB
Host    150.145.139.3:8889
Referer 
User-Agent  Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:20.0) Gecko/20100101 Firefox/20.0
X-Requested-With    XMLHttpRequest

以下是我的代码：

<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);



date_default_timezone_set('Europe/Rome');

require_once 'Classes/PHPExcel.php'; 
/** PHPExcel_IOFactory */
include 'Classes/PHPExcel/IOFactory.php';



$target ='templates/';
$fileType = 'Excel2007';   
$InputFileName = $target.'richiesta.xlsx';   
$OutputFileName = $target     .'Richiesta_'.$_SESSION['User'].'_'.$_SESSION['Last'].'_'.$dat.'.xlsx';



//Read the file (including chart template) 
$objReader = PHPExcel_IOFactory::createReader($fileType); 
//$objReader->setIncludeCharts(TRUE);
$objPHPExcel = $objReader->load($InputFileName); 

 //Change the file 


$objPHPExcel->setActiveSheetIndex(0)
// Add data
            ->setCellValue('C3','10' )
            ->setCellValue('C4','20' )
            ->setCellValue('C5','30')
            ->setCellValue('C5','40' );


$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $fileType);

//$objWriter->save($OutputFileName);  //This one WORKS FINE!!!




header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="Report.xlsx"');


$objWriter->save('php://output'); //NOT WORKING :-(
$objPHPExcel->disconnectWorksheets();
unset($objPHPExcel);

exit;

本周必须完成项目，这个问题让我感到沮丧。非常感谢任何形式的帮助！

- LuferBRA

4个回答

0

 $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
 $filename = '1111';    
 ob_end_clean(); 
 header("Content-Type: application/vnd.openxmlformats- 
 officedocument.spreadsheetml.sheet");
 header('Content-Disposition:attachment;filename="'.$filename.'.xlsx"');
 header("Cache-Control: max-age=0");
 $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
 $writer->save('php://output');
 exit();

- aleksa106

3

请在您的回答中添加一些解释，以便其他人可以从中学习。 - Nico Haase

0

尝试使用这些header()调用：

header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");;
header("Content-Disposition: attachment;filename=Report.xlsx");
header("Content-Transfer-Encoding: binary ");

- Julaine

-1

我曾经遇到过同样的问题，看起来下载必须在不同的标签页中打开，而不是在同一个标签页中直接下载。这意味着在初始化下载之前需要重定向到一个新的标签页。

- CakeFactory

2

@Vikrant 这是一个含糊的答案，但看起来这是回答问题的尝试。 - Joshua Drake

我更愿意说，这是对问题的评论。 - Vikrant

网页内容由stack overflow 提供, 点击上面的

可以查看英文原文，
原文链接

- Axel Amthor · Accepted Answer

这只是我的代码提示，问题似乎与 Content-Type HTTP 头有关：

if (strtolower($type) == 'excel2003') {
    $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5');
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="' . $outFileName . '"');
    header('Cache-Control: max-age=0');
} else {
    $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel2007');
    header('Content-Type: application/xlsx');
    header('Content-Disposition: attachment;filename="' . $outFileName . '"');
    header('Cache-Control: max-age=0');
}