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 CodeIgniter

Using phpxlsx with CodeIgniter is as simple as copying the phpxlsx content package to the application/libraries/phpxlsx directory and load the CreateXlsx class.

To have the phpxlsx API methods available, just load the library in the controller:

public function index()
{
    $this->load->library('phpxlsx/classes/CreateXlsx', '', 'phpxlsx');

    $this->phpxlsx->addCell(array('text' => 'New content'), 'A1');
    $this->phpxlsx->saveXlsx(APPPATH . '/spreadsheets/output.xlsx');
}

In order to save the XLSX, the spreadsheets folder in the APPATH path must have read/write permissions.

Warning

To run phpxlsx with CodeIgniter 4 it is mandatory to use the package that supports namespaces. This package is available for Advanced and Premium licenses.