Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Allow user to set document properties programmatically #55

Open
matt-dray opened this issue Apr 4, 2022 · 3 comments
Open

Allow user to set document properties programmatically #55

matt-dray opened this issue Apr 4, 2022 · 3 comments
Labels
enhancement New feature or request priority: on ice Do much later, maybe never

Comments

@matt-dray
Copy link
Collaborator

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 matt-dray added the enhancement New feature or request label Apr 4, 2022
@matt-dray matt-dray changed the title Set document properties programmatically Set document properties programmatically? Apr 19, 2022
@matt-dray matt-dray added the priority: on ice Do much later, maybe never label Jun 16, 2022
@matt-dray
Copy link
Collaborator Author

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
Copy link
Collaborator Author

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

@matt-dray
Copy link
Collaborator Author

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

@matt-dray matt-dray changed the title Set document properties programmatically? Allow user to set document properties programmatically Dec 28, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request priority: on ice Do much later, maybe never
Projects
None yet
Development

No branches or pull requests

1 participant