Relative Content

Tag Archive for pythonexcelvalidationopenpyxl

How to read data validation rules from an excel sheet in python?

I have a template excel sheet with some data validation rules that I need to populate with data from another source. I need to read the template excel sheet with python and populate the rows and then write it out while preserving the data validation rules that used to exist in the original excel sheet. The template is externally generated and I have no control over it, so I pretty much need to copy the validation rules from there.