Python Forum
Python read Excel cell data validation
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python read Excel cell data validation
#1
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Photo read matlab data pz16 1 1,325 Oct-06-2023, 11:00 PM
Last Post: snippsat
  Data Sorting and filtering(From an Excel File) PY_ALM 0 1,012 Jan-09-2023, 08:14 PM
Last Post: PY_ALM
Smile How to further boost the data read write speed using pandas tjk9501 1 1,231 Nov-14-2022, 01:46 PM
Last Post: jefsummers
  Help with poorly formatted excel data armitron121 1 1,695 Jan-13-2022, 07:31 AM
Last Post: paul18fr
  Exporting data frame to excel dyerlee91 0 1,606 Oct-05-2021, 11:34 AM
Last Post: dyerlee91
  [Pandas] Write data to Excel with dot decimals manonB 1 5,775 May-05-2021, 05:28 PM
Last Post: ibreeden
  excel data erase d8a988 1 2,104 Apr-27-2020, 05:43 PM
Last Post: snippsat
  Read json array data by pandas vipinct 0 1,902 Apr-13-2020, 02:24 PM
Last Post: vipinct
  Read data, recognize trends and send report vin0001 1 2,092 Oct-02-2019, 06:08 AM
Last Post: buran
  Read exel with merged cells and write to another excel SriMekala 0 2,939 Aug-10-2019, 07:14 AM
Last Post: SriMekala

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020