• Categories
    • PHP
    • phpMyAdmin
    • PHPMailer
    • FFMpeg
    • PHPEXcel
    • PHPDoc
    • PHPUnit
    • CakePHP
    • CakePHP 2.0
    • Cake PHP 2.1
    • CakePHP Model
    • Facebook PHP SDK
    • composer-php
    • PHP 7
    • PHP GD
    All Categories
  • About

PHPExcel_IOFactory::createWriter causes wrong behaviour

phpphpexcel


PHP Snippet 1:

07:31:12 Create new PHPExcel object 
07:31:12 Set properties 
07:31:12 Add some data 
07:31:12 Rename sheet 
07:31:12 Write to Excel2007 format 

PHP Snippet 2:

    $objWriter =  PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

    header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    header('Content-Disposition: attachment;filename="workbook1.xlsx"');
    header('Cache-Control: max-age=0');

    ob_end_clean();
    $objWriter->save('php://output');
    exit;

Related Snippets

Docker & Laravel : configure: error: Package requirements (oniguruma) were not met

SlimExceptionHttpNotFoundException

Select option menu read from database and use it's values

The "client_reference_id" argument is not passed

"Unable to load dynamic library 'pdo_sqlsrv.so' "Cenos7 PHP7.2.10

I can't delete my image when it is liked because of the foreign key in mysql

Edit XML in HTML form and submit to self

Split a string array into pieces

How to use PHPCBF to fix one issue at a time?

Sagepay Error The Vendor failed to provide a RedirectionURL

Accessors (Getter) & Mutators (Setter) On a Pivot Table in Laravel

Composer Warning: openssl extension is missing. How to enable in WAMP

Modify microseconds of a PHP DateTime object

passwordless LDAP login and get user information using Kerberos ticket in PHP

Dynamic dropdown Ajax PHP request

About Contact Privacy policy Terms and conditions