Protecting Worksheets in Python

Aspose.Cells - Protecting Worksheets

To protect a worksheet using Aspose.Cells Java for Python, call the protect_worksheet method of the protection module.

Python Code

# Instantiating an Excel object by Excel file path
excel = self.Workbook(self.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(self.dataDir + "output.xls")

# Print message
print "Sheet protected successfully."

Download Running Code

Download Protecting Worksheets (Aspose.Cells) from any of the below‑mentioned social coding sites:

• GitHub