Unprotect a Worksheet in PHP

Aspose.Cells - Unprotect a Worksheet

To unprotect a worksheet using Aspose.Cells Java for PHP, call the unprotect method of the protection module.

PHP Code

$filesFormatType = new FileFormatType();

// Instantiating a Workbook object
$workbook = new Workbook($dataDir . "book1.xls");
$worksheets = $workbook->getWorksheets();
$worksheet = $worksheets->get(0);
$protection = $worksheet->getProtection();

// Unprotecting the worksheet with a password
$worksheet->unprotect("aspose");

// Save the Excel file.
$workbook->save($dataDir . "output.xls", $filesFormatType->EXCEL_97_TO_2003);

Download Running Code

Download Unprotect a Worksheet (Aspose.Cells) from any of the below-mentioned social coding sites:

• GitHub