unmergeCells

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXPATH

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

unmergeCells

ADVANCED / PREMIUM

BASIC

Unmerges cells in the spreadsheet.

Description

public unmergeCells ($position)

Parameters

position

Cell range or cell (first position) to be unmerged: A2:D2, C2:E4, A2...

Exceptions

Method not available.

Invalid position.

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

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

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

$xlsx->unmergeCells('B5:D5');
// the first cell position can also be set
//$xlsx->unmergeCells('B5');

$xlsx->saveXlsx('output');

Release notes

phpxlsx 5.5:
- new method.