addDefinedName

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

addDefinedName

BASIC / ADVANCED / PREMIUM

Adds defined names into the Excel spreadsheet.

Description

public addDefinedName($name, $value, $options = array())

This method allows adding a defined name to a range of cells.

Parameters

name

Defined name.

value

Defined name value.

Exceptions

Defined name exists.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

$content = array(
    'text' => 100,
);
$xlsx->addCell($content, 'A2');
$content = array(
    'text' => 10.50,
);
$xlsx->addCell($content, 'A3');

$xlsx->addDefinedName('MY_SUM', 'Sheet1!$A$2:$A$3');

$contentStyles = array(
    'bold' => true,
    'font' => 'Arial',
);
$cellStyles = array(
    'backgroundColor' => 'FFFF00',
    'verticalAlign' => 'top',
);
$xlsx->addFunction('=SUM(MY_SUM)', 'D3', $contentStyles, $cellStyles);

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 2.5:
- new method.