addBreak

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

addBreak

BASIC / ADVANCED / PREMIUM

Inserts a row or column break into the Excel spreadsheet.

Description

public addBreak($position, $type = 'row')

This method allows the insertion of a break into the sheet.

Parameters

position

Integer value: 1, 2, 5...

type

'row' or 'col'.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

// add sample contents
$content = array(
    'text' => 'First content.',
);
$xlsx->addCell($content, 'A1');

$content = array(
    'text' => 'Next content.',
);
$xlsx->addCell($content, 'A5');

$content = array(
    'text' => 'Other content.',
);
$xlsx->addCell($content, 'F10');

// add breaks
$xlsx->addBreak(2, 'row');

$xlsx->addBreak(4, 'row');

$xlsx->addBreak(5, 'col');

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 1.0: new method.