feature request: Parse Workbook Properties

[Alex-ley-scrub]

Feature Request

see: ToucanToco/fastexcel#495

Would it be possible to parse Workbook Properties? I am not sure if they are inside of https://docs.rs/calamine/latest/calamine/struct.Xlsx.html#method.metadata?

e.g. I usually do something like this with openpyxl and it would be nice to do it with fastexcel instead.

wb = load_workbook(...)
author = wb.properties.creator
user = wb.properties.lastModifiedBy

[jmcnamara]

This is a reasonable request. I'll try to get to it for xlsx in the current release cycle.

There is a suitable struct and test files in rust_xlsxwriter: https://docs.rs/rust_xlsxwriter/latest/rust_xlsxwriter/struct.DocProperties.html

Would also close #149

[Alex-ley-scrub]

Hi @jmcnamara

I've put together an MVP implementation for parsing workbook properties in #685.

It exposes both core (docProps/core.xml) and extended (docProps/app.xml) properties via a new Metadata::workbook_properties() method, including the creator and last_modified_by fields mentioned here and in #149

Any feedback is welcome!

[Alex-ley-scrub]

@jmcnamara the PR tests did previously pass but I just resolved a new conflict on that PR and the tests are now waiting to be approved to run again.