• 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

PHP sort array of objects by two properties

Laravel Multi-language routes without prefix

php mysql + create a friend request system

Laravel print last executed SQL query with Query log

storagelogs/laravel.log" could not be opened in append mode: failed to open stream: Permission denied

How to convert time from one timezone to another in PHP

Target class controller does not exist - Laravel 8

How to test laravel controller method?

How to install ZeroMQ for PHP on an Alpine Linux container?

Laravel Schedule not sending email

Change the alert text on add to cart action without selected variation in Woocommerce

Laravel Factory not calling callback 'afterCreating'

Display the WooCommerce product price inside a custom function

Display Brand Name Above Product Title in Woocommerce Cart, Checkout Page, Orders and Email Notification

Split array into 4-element chunks then implode into strings

About Contact Privacy policy Terms and conditions