Difference between #18 and #19 of
Yii v2 snippet guide II

Revision #19 has been created by rackycz on Sep 8, 2020, 7:39:51 PM with the memo:

Composer and PhpExcel
« previous (#18) next (#20) »

Changes

Title unchanged

Yii v2 snippet guide II

Category unchanged

Tutorials

Yii version unchanged

2.0

Tags unchanged

tutorial,beginner,yii2,snippets

Content changed

[...]
header('Cache-Control: max-age=0');
$writer->save('php://output');
exit();
```

Thanks to [DbCreator](https://forum.yiiframework.com/t/yii2-phpoffice-phpspreadsheet-src-phpspreadsheet-shared-ole-pps-root-php-on-line-292-headers-already-sent/126617) for the latter approach. Other ways did not work for me.
 
 
Following is my idea:
 
 
```php
 
ob_start();
 
ob_implicit_flush(false);
 
$writer->save($outputFileName);
 
$file = ob_get_clean();
 
 
return \Yii::$app->response->sendContentAsFile($file, 'file.xlsx',[
 
  'mimeType' => 'application/application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
 
  'inline' => false
 
]);
 
```
 
4 0
3 followers
Viewed: 68 817 times
Version: 2.0
Category: Tutorials
Tags: beginner, snippets, tutorial, yii2
Written by: rackycz
Last updated by: rackycz
Created on: Aug 26, 2020
Last updated: 2 years ago
Update Article
Revert to #18 | Revert to #19

Revisions

View all history