as with Python it is possible to detect, validate, read, compare or know the format or style of one or several cells in Excel, to be able to filter and / or discard by color.
as with Python it is possible to detect, validate, read, compare or know the format or style of one or several cells in Excel, to be able to filter and / or discard by color.
There is a library called xlwings , it may be useful for what you want to do. According to the documentation , to declare or get the color of a cell you can do the following:
>>> import xlwings as xw
>>> wb = xw.Book()
>>> xw.Range('A1').color = (255,255,255)
>>> xw.Range('A2').color
(255, 255, 255)
>>> xw.Range('A2').color = None
>>> xw.Range('A2').color is None
True
Currently xlwings is only compatible with Windows and OSX.