Allow user to set document properties programmatically
Opened this issue · 3 comments
matt-dray commented
Is there a programmatic way to adjust document 'properties', i.e. the meta information associated with a spreadsheet file that lists the title, subject, author, category, etc?
This can be found and adjusted manually via File > Properties in spreadsheet programs.
matt-dray commented
To note: this is something that the gptables team would also like to solve, but is also proving difficult in Python given the limits of the xlsx-related packages being wrapped.
matt-dray commented
{dftutils} has a clean_metadata() function that could be useful here; thanks @DIPAD-Fran-Bryden for making me aware of this package.