removeProtection

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

FORMAT CONVERSION

transform

XLSXUTILITIES

INDEXER

indexer

PERFORMANCE

zipStream

CRYPTO

DIGITAL SIGNATURE

sign (XLSX)

removeProtection

PREMIUM

BASIC / ADVANCED

Removes the password protection from an Excel spreadsheet.

Description

public removeProtection($source, $target, $options = array())

This method allows you to remove the protection from a password protected Excel spreadsheet.

Parameters

source

Path to the password protected Excel spreadsheet.

target

Path where you want to save the resulting unprotected spreadsheet.

options

The possible keys and values are:

Key	Type	Description
removeSheetsProtection	bool	If true remove sheets protection. Default as true.
removeWorksheetProtection	bool	If true remove worksheet protection. Default as true.
sheetsSelection	array	Sheets to remove protectition: 'names' or 'positions'. If not set, all sheet protections are removed.

Exceptions

The source file doesn't exist.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CryptoXlsx();

$options = array(
    'password' => 'phpxlsx',
    'scope' => 'worksheet',
);
$xlsx->removeProtection('file.xlsx', 'output.xlsx', $options);

Example #2

require_once 'classes/CreateXlsx.php';

$xlsx = new CryptoXlsx();

$options = array(
    'sheetsSelection' => array('positions' => array(0, 2)),
);
$xlsx->removeProtection('file.xlsx', 'output.xlsx', $options);

Release notes

phpxlsx 1.0:
- new method.