Cookbook

INTRODUCTION

Learn phpxlsx in 5 minutes

PRACTICAL PHPXLSX

Installation
Creating a new spreadsheet
Adding contents
Working with templates
Images
Charts
HTML and CSS
Tables
Headers and footers
Settings
Get information
Format transformations
Protect, encrypt and sign
More features

CONVERSION PLUGIN

Information
Conversion plugin installation and set up
Running the first example and available options
Preparing the documents for their conversion
Common problems and possible errors
Debugging LibreOffice

COOKBOOK

SNIPPETS

API DOCUMENTATION

Integrate phpxlsx with Zend Framework 1

1- Copy the content of the phpxlsx package and paste it in the library/phpxlsx directory.
2- Open the file index.php of the app and add to it the following lines after the require_once of Zend/Application.php:

// Ensure library/ is on include_path
set_include_path(implode(PATH_SEPARATOR, array(
    realpath(APPLICATION_PATH . '/../../library/phpxlsx/classes'),
    get_include_path(),
)));

/** Phpxlsx */
require_once 'CreateXlsx.php';

With these two easy steps you are ready to work with phpxlsx. As a practical example, let's create a XLSX in a controller and save it in the public directory with the name output.xlsx:

$xlsx = new CreateXlsx();

$xlsx->addCell(array('text' => 'New content'), 'A1');
$xlsx->saveXlsx(realpath(APPLICATION_PATH . '/../public/') . '/output.xlsx');