Managing Document Properties in Python

Aspose.Cells - Managing Document Properties

Developers can make use of the Index or Name of the property to get a specific property from a custom_properties collection as demonstrated below in the example.

Python Code

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

# Retrieve a list of all custom document properties of the Excel file
customProperties = workbook.getWorksheets().getCustomDocumentProperties()

# Accessing a custom document property by using the property index
# customProperty1 = customProperties.get(3)

# Accessing a custom document property by using the property name
customProperty2 = customProperties.get("Owner")

# Adding a custom document property to the Excel file
publisher = customProperties.add("Publisher", "Aspose")

# Save the file
workbook.save(self.dataDir + "Test_Workbook.xls")

# Removing a custom document property
customProperties.remove("Publisher")

# Save the file
workbook.save(self.dataDir + "Test_Workbook_RemovedProperty.xls")

# Print message
print "Excel file's custom properties accessed successfully."

Download Running Code

Download Hello World (Aspose.Cells) from any of the social coding sites mentioned below:

• GitHub