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

Include data_validation in template #291

Open
Shettland opened this issue Aug 23, 2024 · 0 comments
Open

Include data_validation in template #291

Shettland opened this issue Aug 23, 2024 · 0 comments
Labels
enhancement New feature or request

Comments

@Shettland
Copy link
Member

A good feature for build_schema would be to already include data validation here, giving the users only a certain list of fields to choose from for each column as a dropdown menu. These should be based on the enums of the corresponding property from the processed schema: https://xlsxwriter.readthedocs.io/working_with_data_validation.html#working-with-data-validation

A nice addition could be to optionally lock the header and first column so they cannot be modified by the users. Reference on how to set a custom password and lock cells with add_format() here: https://xlsxwriter.readthedocs.io/format.html#set_locked

Here's a reference that I found on how to solve this task: https://stackoverflow.com/questions/51497731/openpyxl-is-it-possible-to-create-a-dropdown-menu-in-an-excel-sheet

Originally posted by @Shettland in #273 (comment)

@Shettland Shettland added the enhancement New feature or request label Aug 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant