Jan-31-2020, 04:57 PM
How can I read Excel cell data validation rules in Python?
from openpyxl.cell, I can read only value, is_date, font, border, fill, umber_format,alignment, data_type. There is no data validation rule read in this API.
The reason I need to read data validation rules, because I am comparing Master template with the data submitted version of the Master template by client so that I can validate metadata including data validation rules in Excel so that we can identify that original template is not changed.
For example: following is the way to write Data Validation in Python. HOW could i find find API to read data validation from Excel Cell.
worksheet.data_validation('B25', {'validate': 'integer', 'criteria': 'between', 'minimum': 1, 'maximum': 100, 'input_title': 'Enter an integer:', 'input_message': 'between 1 and 100'})
Will xlwings be of any help?
Thanks Anant
from openpyxl.cell, I can read only value, is_date, font, border, fill, umber_format,alignment, data_type. There is no data validation rule read in this API.
The reason I need to read data validation rules, because I am comparing Master template with the data submitted version of the Master template by client so that I can validate metadata including data validation rules in Excel so that we can identify that original template is not changed.
For example: following is the way to write Data Validation in Python. HOW could i find find API to read data validation from Excel Cell.
worksheet.data_validation('B25', {'validate': 'integer', 'criteria': 'between', 'minimum': 1, 'maximum': 100, 'input_title': 'Enter an integer:', 'input_message': 'between 1 and 100'})
Will xlwings be of any help?
Thanks Anant