• 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

Transfer data between JavaScript and PHP through JSON

How to make a array inside array?

Attempted to call an undefined method named "get" of class "MailController"

Laravel 4 Redirect::back() not going to previous page (refreshing current page)

JSON Render Issue in Date Object Laravel and PHP 7.4

Search for array row with specific column value and return another value from qualifying row

VichUploaderBundle error "Expected argument of type "File", "NULL" given" when submitting the form without selecting any file

Problem with fetching data from database in Laravel

if statement inside concatenation

Converting IPv6 to IPv4 address in PHP

wordpress function breaks wp-admin

How to extract price from given url using Xpath?

Get data from accuweather api url

How to add a custom field to all Woocommerce attribute terms using add_action

renameColumn migration fails for existing column with columns does not exist error

About Contact Privacy policy Terms and conditions