removeVariableText

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

removeVariableText

BASIC / ADVANCED / PREMIUM

Removes text placeholder variables from the Excel spreadsheet.

Description

public removeVariableText($variables, $options = array())

This method allows to remove text placeholder variables.

Parameters

$variables

Array of variables to remove.

options

Key	Type	Description
target	string	sheets (default) [sharedStrings XML content], headers, footers, comments.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsxFromTemplate('template.xlsx');

// remove variables in the sheets target
$xlsx->removeVariableText(array('VAR_1', 'VAR_2'), array('target' => 'sheets'));

// remove variables in the footers and headers targets
$xlsx->removeVariableText(array('VAR_HEADER_2', 'HEADERS_1_1', 'HEADERS_1_2'), array('target' => 'headers'));
$xlsx->removeVariableText(array('VAR_FOOTER_2', 'FOOTER_1_3', 'FOOTER_3_3'), array('target' => 'footers'));

// remove variables in the comments target
$xlsx->removeVariableText(array('VAR_COMMENT'), array('target' => 'comments'));

$xlsx->saveXlsx('output');

Release notes

phpxlsx 1.0:
- new method.