Snippets

INTRODUCTION

Learn phpxlsx in 5 minutes

PRACTICAL PHPXLSX

Installation
Creating a new spreadsheet
Adding contents
Working with templates
Images
Charts
HTML and CSS
Tables
Headers and footers
Settings
Get information
Format transformations
Protect, encrypt and sign
More features

CONVERSION PLUGIN

Information
Conversion plugin installation and set up
Running the first example and available options
Preparing the documents for their conversion
Common problems and possible errors
Debugging LibreOffice

COOKBOOK

SNIPPETS

API DOCUMENTATION

Replace placeholders in all targets

By default, phpxlsx template methods replace placeholders in the sharedStrings content. To replace in other contents of the spreadsheet you must set it in the target option.

The following code replaces placeholders in all targets:

foreach (array('sheets', 'headers', 'footers', 'comments') as $target) {
    $xlsx->replaceVariableText($variables, array('target' => $target));
}

This snippet can be used along with other placeholder replacement methods.