Cookbook

• 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');

​