在Php中保护工作表
Contents
[
Hide
]
Aspose.Cells - 保护工作表
要使用Aspose.Cells Java for PHP保护工作表，请调用protection模块的protect_worksheet方法。
PHP 代码
//Instantiating a Excel object by excel file path
$excel = new Workbook($dataDir . "book1.xls");
//Accessing the first worksheet in the Excel file
$worksheets = $excel->getWorksheets();
$worksheet = $worksheets->get(0);
$protection = $worksheet->getProtection();
//The following 3 methods are only for Excel 2000 and earlier formats
$protection->setAllowEditingContent(false);
$protection->setAllowEditingObject(false);
$protection->setAllowEditingScenario(false);
//Protects the first worksheet with a password "1234"
$protection->setPassword("1234");
//Saving the modified Excel file in default format
$excel->save($dataDir . "output.xls");
下载运行代码
从下面提到的任何社交编码网站下载Protecting Worksheets (Aspose.Cells)。