Practical phpxlsx

Tables

Introduction

Tables allow inserting, grouping and managing a range of cells.

Additional options can be used to apply styles, customize column names, include functions and add filters.

Adding tables

The method for adding new tables in the active sheet is addTable:

    public function addTable($contents, $position, $tableStyles = array(), $options = array())

This method includes the following parameters:

$contents: a multidimensional array with the contents and styles to be added
$position: cell position in the active sheet (A1, C3, AB7...)
$tableStyles: table styles
$options: column names, table name, totals, filters...

A very simple table can be created running:

$contents = array(
    array(10),
    array(20),
    array(55),
    array(32),
);
$xlsx->addTable($contents, 'B3');

Complex tables can be done, adding multiple columns, styles and total functions:

$contents = array(
    array(
        10,
        50,
    ),
    array(
        20,
        25.5,
    ),
    array(
        55,
        12,
    ),
    array(
        32,
        36,
    ),
);
$tableStyles = array(
    'totalRow' => true,
);

// table with max and count as row totals
$options = array(
    'columnNames' => array(
        array(
            'text' => 'Values 1',
        ),
        array(
            'text' => 'Values 2',
        ),
    ),
    'columnTotals' => array(
        array(
            'type' => 'function',
            'value' => 'max',
            'contentStyles' => array(
                'bold' => true,
            ),
            'cellStyles' => array(
                'backgroundColor' => 'FFFF00',
            ),
        ),
        array(
            'type' => 'function',
            'value' => 'count',
            'contentStyles' => array(
                'bold' => true,
            ),
            'cellStyles' => array(
                'backgroundColor' => 'FFFF00',
            ),
        ),
    ),
);
$xlsx->addTable($contents, 'B3', $tableStyles, $options);

Tips and tricks

Table and column names are generated automatically. Custom names can be set in the $options parameter.

Table names must be unique.

The addTable method returns an array with the position range added.

Custom table styles can be generated using createTableStyle.

Next - Headers and footers