Display Document Properties in Excel using Python

This topic covers how to display document properties in Excel using Python. It encompasses the details to configure the IDE for using this feature, a list of programming steps to accomplish the task, and an example code displaying the Excel file properties using Python. You will also be enlightened to access the built-in and custom properties using different arguments as parameters.

Steps to Display Document Properties in Excel using Python

  1. Set the IDE to use Aspose.Cells for Python via Java to read properties
  2. Open the source Excel file into the Workbook class to display the properties
  3. Iterate through all the custom document properties in the workbook and display the property names and values in the output console
  4. Loop through all the builtin properties and display name and values in the output console
  5. Access various other properties using property name or index

The above steps briefly explain how to display document properties in Excel using Python. Access the source Excel file, loop through all the custom/built-in properties, and output a few properties like name and value. Access the individual document properties using the property name or index as per the requirements.

Code to Show Excel Document Properties using Python

This example code has exhibited how to display properties in Excel using Python. It is important to mention that custom properties will be displayed if available in the Excel files, however, the built-in properties are always displayed by default. To manage the individual property, you can use any other built-in properties like LastSavedBy, Author, CreateTime, LastSavedTime, Version, etc.

This topic has enlightened us to access and display the properties in an Excel file. To remove page breaks in an Excel file, refer to the article on Remove Page Break in Excel using Python.

 English