addLink

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

addLink

BASIC / ADVANCED / PREMIUM

Adds links into the Excel spreadsheet.

Description

public addLink($link, $position, $contents = array(), $cellStyles = array(), $options = array())

This method allows adding a link into a position.

Parameters

link

URL or #location.

position

Cell position in the active sheet: A1, C3, AB7...

contents

Check addCell to see all available options.

cellStyles

Check addCell to see all available options.

options

Check addCell to see all available options.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

$content = array(
    'text' => 'Link to phpxlsx',
);
$xlsx->addLink('https://www.phpxlsx.com', 'B2', $content);

$content = array(
    'text' => 'Link to phpdocx',
    'bold' => true,
    'color' => '000000',
    'underline' => 'none',
);
$xlsx->addLink('https://www.phpdocx.com', 'D5', $content);

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Example #2

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

// add new sheets
$xlsx->addSheet(array('name'=> 'Sheet2'));

$content = array(
    'text' => 'Link to Sheet2',
);
$xlsx->addLink('#Sheet2!A1', 'A1', $content);

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 1.0:
- new method.