Breaking News: Grepper is joining You.com. Read the official announcement!

phpspreadsheet password protected

Shadow answered on July 18, 2022 Popularity 6/10 Helpfulness 7/10

answer phpspreadsheet password protected

phpspreadsheet password protected

Comment

// Set document security
$helper->log('Set document security');
$spreadsheet->getSecurity()->setLockWindows(true);
$spreadsheet->getSecurity()->setLockStructure(true);
$spreadsheet->getSecurity()->setWorkbookPassword('PhpSpreadsheet');

// Set sheet security
$helper->log('Set sheet security');
$spreadsheet->getActiveSheet()->getProtection()->setPassword('PhpSpreadsheet');
$spreadsheet->getActiveSheet()->getProtection()->setSheet(true); // This should be enabled in order to enable any of the following!
$spreadsheet->getActiveSheet()->getProtection()->setSort(true);
$spreadsheet->getActiveSheet()->getProtection()->setInsertRows(true);
$spreadsheet->getActiveSheet()->getProtection()->setFormatCells(true);

Popularity 6/10 Helpfulness 7/10 Language php

Source: Grepper

Tags: php phpspreadsheet protected

Link to this answer
Share Copy Link

Contributed on Jul 18 2022

Shadow

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

phpspreadsheet password protected

Contents

More Related Answers

phpspreadsheet password protected

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.