dongyu5104
dongyu5104
2018-08-17 10:18
浏览 61
已采纳

Zend Framework CSV下载

I am currently working on a CSV generator in Zend Framwork. At this point I am able to create a valid CSV file on the server side and now I want to download that file. I am currently using the following code:

$reader = new \PHPExcel_Reader_CSV();
$reader->setReadDataOnly(true);

$excel = $reader->load($file); //$file = Path of the csv file in the local storage

$writer = \PHPExcel_IOFactory::createWriter($excel, 'CSV');

$path = 'public/download';
$fileName = 'test.csv';

$writer->save($path . '/' . $fileName);

$response = new ResponseStream();
$response->setStream(fopen($path . '/' . $fileName, 'r'));

$headers = new Headers();
$headers->addHeaders([
    'Content-Type' => [
        'application/force-download',
        'application/octet-stream',
        'application/download'
    ],
    'Content-Length' => filesize($path . '/' . $fileName),
    'Content-Disposition' => 'attachment;filename=' . $fileName,
    'Cache-Control' => 'must-revalidate',
    'Pragma' => 'no-cache',
    'Expires' => 'Thu, 1 Jan 1970 00:00:00 GMT'
]);

$response->setHeaders($headers);

$cookie = new SetCookie('downloadComplete', 'true', time() + 60 * 60, '/');
$response->getHeaders()->addHeader($cookie);

$response->setContent($writer);

return $response;

The problem is now that I only get a Zend error popup:

statusCode 200 thrownError SyntaxError: JSON.parse: unexpected non-whitespace character after JSON data at line 1 column 21 of the JSON data

And the content of my CSV as response text.

Do you have an idea? Thanks in advance.

图片转代码服务由CSDN问答提供 功能建议

我目前正在使用Zend Framwork中的CSV生成器。 此时我可以在服务器端创建一个有效的CSV文件,现在我想下载该文件。 我目前正在使用以下代码:

  $ reader = new \ PHPExcel_Reader_CSV(); 
 $ reader-> setReadDataOnly(true); 
 
 $ excel =  $阅读器 - >负载($文件);  // $ file =本地存储中的csv文件的路径
 
 $ writer = \ PHPExcel_IOFactory :: createWriter($ excel,'CSV'); 
 
 $ path ='public / download'; 
  $ fileName ='test.csv'; 
 
 $ writer-> save($ path。'/'。$ fileName); 
 
 $ response = new ResponseStream(); 
 $ response->  setStream(fopen($ path。'/'。$ fileName,'r')); 
 
 $ headers = new Headers(); 
 $ headers-> addHeaders([
'Content-Type'=  > [
'application / force-download',
'application / octet-stream',
'application / download'
],
'Intent-Length'=> filesize($ path。'  /'。$ fileName),
'Content-Disposition'=>'attachment; filename ='。$ fileName,
'Cache-Control'=>'must-revalidate',
'Pragma'=&gt  ;'no-cache',
'Expires'=>'星期四,1970年1月1日00:00:00 GMT'
]); 
 
 $ response-> setHeaders($ headers); 
  
 $ cookie = new SetCookie('downloadComplete','true',time()+ 60 * 60,'/'); 
 $ response-> getHeaders() - > addHeader($ cookie); 
  
 $的响应 - > setContent($作家); 
 
return  $ response; 
   
 
 

问题是我现在只得到一个Zend错误弹出窗口:

  statusCode 200 thrownError  SyntaxError:JSON.parse:JSON数据的第1行第21行的JSON数据之后的意外非空白字符
   
 
 

以及我的CSV内容作为响应文本。

您有什么想法吗? 提前谢谢。

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dsagzmosl32217092
    dsagzmosl32217092 2018-08-20 14:00
    已采纳

    After a lot of investigation I found out that the download only fails if we send a Post request to the download action via zend (I assume it overrides the self-setted headers). So I sendt the request via a java script redirect ($viewModel->addScriptBlock('window.location = "Your URL";');) and it worked.

    点赞 评论

相关推荐