mergeCells

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

mergeCells

ADVANCED / PREMIUM

BASIC

Merges cells in the spreadsheet.

Description

public mergeCells ($position, array $options = array())

Parameters

position

Cell range to be merged: A2:D2, C2:E4...

options

key	Type	Description
emptyExtraMergedCells	bool	Empty merged cell contents from upper-left value. Default as true.

Exceptions

Method not available.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

$content = array(
    'text' => 'New cell',
);
$xlsx->addCell($content, 'A1');
$content = array(
    'text' => 'Other cell',
);
$xlsx->addCell($content, 'A2');

$content = array(
    'text' => 'Centered cell',
    'bold' => true,
    'italic' => true,
    'underline' => 'single',
);
$styles = array(
    'horizontalAlign' => 'center',
);
$xlsx->addCell($content, 'B5', $styles);

$content = array(
    'text' => 'Cell content C5',
    'color' => '13775F',
);
$xlsx->addCell($content, 'C5');

$content = array(
    'text' => 'Cell content C5',
    'color' => '13775F',
);
$xlsx->addCell($content, 'D5');

$xlsx->mergeCells('A1:C1');

$xlsx->mergeCells('B5:D5');

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 5.0:
- new method.