searchAndReplace

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

searchAndReplace

ADVANCED / PREMIUM

BASIC

Searches and replaces shared strings and cell values in an Excel spreadsheet.

Description

public searchAndReplace($source, $target, $data, $scope, $options = array())

This method allows the substitution of plain strings and cell values in an XLSX spreadsheet.

Parameters

source

The path to the source XLSX file.

target

The path to the XLSX file resulting after the text replacement.

data

The data to be replaced. Plain strings or an array with the following keys: row (row number), col (column number to replace, 1 as first position) and value (value to add).

scope

sharedStrings (text strings) or sheet (cell values).

options

The possible keys and values are:

Key	Type	Description
sheetName	string	Sheet name to replace the value when using sheet as scope. All if null.
sheetNumber	int	Sheet number to replace the value when using sheet as scope. All if null.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new XlsxUtilities();

$data = array('A1' => 'First cell', 'B3' => 'other cell', 'A1 B1 merged Sheet 2' => 'Merged cells');

$xlsx->searchAndReplace('file.xlsx', 'output.xlsx', $data, 'sharedStrings');

Example #2

require_once 'classes/CreateXlsx.php';

$xlsx = new XlsxUtilities();

$data = array(
    array(
        'row' => 2,
        'col' => 1,
        'value' => 30,
    ),
    array(
        'row' => 2,
        'col' => 2,
        'value' => 10,
    ),
    array(
        'row' => 2,
        'col' => 3,
        'value' => 5,
    ),
    array(
        'row' => 4,
        'col' => 2,
        'value' => 3,
    ),
);

$xlsx->searchAndReplace('file.xlsx', 'output.xlsx', $data, 'sheet', array('sheetName' => 'Chart'));

Release notes

phpxlsx 1.0:
- new method.