search

co-analysis / a11ytables

R package: generate best-practice stats spreadsheets for publication
https://co-analysis.github.io/a11ytables/
Other
42 stars 3 forks source link

Allow user to set document properties programmatically #55

Open matt-dray opened 2 years ago

matt-dray commented 2 years ago

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 2 years ago

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 11 months ago

{dftutils} has a clean_metadata() function that could be useful here; thanks @DIPAD-Fran-Bryden for making me aware of this package.

matt-dray commented 10 months ago

You can set_properties as a method in {openxlsx2}, useful for #70.