取消保护 Python 中的工作表

Aspose.Cells - 取消保护工作表

保护工作表使用Aspose.Cells Java for Python, 称呼取消保护工作表的方法保护模块。

Python 代码

 filesFormatType = self.FileFormatType

# Instantiating a Workbook object

workbook = self.Workbook(self.dataDir + "Book1.xls")

worksheets = workbook.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)

# Unprotecting the worksheet

worksheet.unprotect()

\# Save the excel file.

workbook.save(self.dataDir + "output.xls", filesFormatType.EXCEL_97_TO_2003)

# Print Message

print "Worksheet unprotected successfully."

下载运行代码

下载**取消保护工作表 (Aspose.Cells)**来自以下任何社交编码网站: