# visualizer/3.9.4/vendor/phpoffice/phpspreadsheet/samples/Basic/12_CellProtection.php

Visualizer – Tables & Charts Manager with Built-in AI Generator, version 3.9.4. 48 lines.

- Page: https://pluginprobe.com/plugins/visualizer/3.9.4/code/vendor/phpoffice/phpspreadsheet/samples/Basic/12_CellProtection.php
- Raw: https://pluginprobe.com/plugins/visualizer/3.9.4/raw/vendor/phpoffice/phpspreadsheet/samples/Basic/12_CellProtection.php
- Modified: 2019-02-24T07:50:56+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/visualizer/3.9.4/code/vendor/phpoffice/phpspreadsheet/samples/Basic/12_CellProtection.php#L10-L20`.

```php
<?php

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Protection;

require __DIR__ . '/../Header.php';

// Create new Spreadsheet object
$helper->log('Create new Spreadsheet object');
$spreadsheet = new Spreadsheet();

// Set document properties
$helper->log('Set document properties');
$spreadsheet->getProperties()->setCreator('Mark Baker')
    ->setLastModifiedBy('Mark Baker')
    ->setTitle('Office 2007 XLSX Test Document')
    ->setSubject('Office 2007 XLSX Test Document')
    ->setDescription('Test document for Office 2007 XLSX, generated using PHP classes.')
    ->setKeywords('office 2007 openxml php')
    ->setCategory('Test result file');

// Add some data
$helper->log('Add some data');
$spreadsheet->setActiveSheetIndex(0);
$spreadsheet->getActiveSheet()->setCellValue('A1', 'Crouching');
$spreadsheet->getActiveSheet()->setCellValue('B1', 'Tiger');
$spreadsheet->getActiveSheet()->setCellValue('A2', 'Hidden');
$spreadsheet->getActiveSheet()->setCellValue('B2', 'Dragon');

// Rename worksheet
$helper->log('Rename worksheet');
$spreadsheet->getActiveSheet()->setTitle('Simple');

// Set document security
$helper->log('Set cell protection');

// Set sheet security
$helper->log('Set sheet security');
$spreadsheet->getActiveSheet()->getProtection()->setSheet(true);
$spreadsheet->getActiveSheet()
    ->getStyle('A2:B2')
    ->getProtection()->setLocked(
        Protection::PROTECTION_UNPROTECTED
    );

// Save
$helper->write($spreadsheet, __FILE__);

```