Search code examples
pythonxlrd

Read workbook properties using python and xlrd

Is there a way to read the excel file properties using xlrd? I refer not to cell presentation properties, but general workbook properties.

Thanks a lot in advance.

Solution

  • Apart from the username (last person to save the worksheet) the Book instance as returned by open_workbook does not seem to have any properties.

    I recursively dumped the Book ( dumping its dict if a xlrd.BaseObject) and could not find anything in that way. The test files for sure had an author, company and some custom metadata.

    FWIW: LibreOffice does not seem to be able to find author and company either (or does not display them), but it does show custom metadata in the properties.