How to create Excel file in PHP


| Tutorial 03
| This tutorial shows how to create an Excel file (1) that has 
| multiple sheets (2) in PHP. The created Excel file is empty and the 
| next tutorial shows how to add data into sheets.
* ==========================================================================*/
Click here to see the Excel file

header("Content-Type: text/html");
echo "Tutorial 03<br>";
echo "----------<br>";
// Create an instance of the class that creates Excel files (1) 
$workbook = new COM("EasyXLS.ExcelDocument");

// Create two sheets (2) 
$workbook->easy_addWorksheet_2("First tab");
$workbook->easy_addWorksheet_2("Second tab");

// Create Excel file
echo "Writing file: C:\Samples\Tutorial03.xlsx<br>";

// Confirm the creation of Excel file
if ($workbook->easy_getError() == "")
    echo "File successfully created.";
    echo "Error encountered: " . $workbook->easy_getError();

// Dispose memory
$workbook = null;


Overloaded methods
For methods with same name but different parameters, only the first method overload retains the original name. Subsequent overloads are uniquely renamed by appending to the method name '_2', '_3', etc (method, method_2, method_3), an integer that corresponds to the order of declaration that can be found in EasyXLS.h, a file that comes with EasyXLS installation.

Linux and PHP
This code sample works just the way it is for PHP on Windows, but PHP under Linux requires also PHP/Java Bridge and a similar code sample in Java.

EasyXLS Excel libraries:

Excel Library for PHP
full COM+ version to import, export or convert Excel files
Excel Writer for PHP
COM+ version to create and export Excel files
Download EasyXLS™ Excel Library for PHP

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019