How to generate an Excel document with multiple worksheets from PHP?

by

Try looking at PHPExcel. This is a simple example that creates an Excel file with two sheets:

<?php
require_once 'PHPExcel.php';
require_once 'PHPExcel/IOFactory.php';

// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

// Create a first sheet, representing sales data
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Something');

// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Name of Sheet 1');

// Create a new worksheet, after the default sheet
$objPHPExcel->createSheet();

// Add some data to the second sheet, resembling some different data types
$objPHPExcel->setActiveSheetIndex(1);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'More data');

// Rename 2nd sheet
$objPHPExcel->getActiveSheet()->setTitle('Second sheet');

// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="name_of_file.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');

More Related Contents:

  1. How to generate an .xlsx using php
  2. Save output in an xml file [closed]
  3. URL Redirect / URL Masking [closed]
  4. I don’t know what’s wrong with my code. I’m a newbie. The prob is – Notice: Undefined variable: result [duplicate]
  5. Get the full URL in PHP
  6. Replace URLs in text with HTML links
  7. How to enable cURL in PHP / XAMPP
  8. Laravel : Syntax error or access violation: 1055 Error
  9. Replace the Variable Price range by the chosen variation price in WooCommerce 3
  10. Warning about `$HTTP_RAW_POST_DATA` being deprecated
  11. How to get the value of an attribute from XML file in PHP?
  12. The first day of the current month in php using date_modify as DateTime object
  13. Is there any way to compile a blade template from a string?
  14. check if download is completed
  15. Is there a PHP Sandbox, something like JSFiddle is to JS? [closed]
  16. mysqli ignoring the first row in a table
  17. PHP Create and Save a txt file to root directory
  18. Artisan migrate could not find driver
  19. How to write a recursive regex that matches nested parentheses?
  20. PHP number format
  21. Using WGET to run a cronjob PHP
  22. Scale Image Using PHP and Maintaining Aspect Ratio
  23. What is the best way to insert multiple rows in PHP PDO MYSQL?
  24. Why doesn’t PHP print TRUE/FALSE? [duplicate]
  25. Move an array element to a new index in PHP
  26. Reference Guide: What does this symbol mean in PHP? (PHP Syntax)
  27. Detecting file upload size on the client side?
  28. Validate Email in php [duplicate]
  29. Is there a function similar to setTimeout() (JavaScript) for PHP?
  30. PDO and MySQL ‘between’

Leave a Comment