Python win32com excel remove interior color

python excel win32com

Solution 1:

Use -4142, which is the corresponding value for xlNone:

xlNone = -4142
ws.Cells(r,c).Interior.Color = xlNone

Or instead of hard-coding, use EnsureDispatch() and then client.constants.xlNone:

from win32com import client
xl=client.gencache.EnsureDispatch('Excel.Application')

ws.Cells(r,c).Interior.Color = client.constants.xlNone

Related

What does returning URLs in a REST API response pointing to the location of resources allow for?
flatten object made of nested list in terraform
Need SQL Server HASHBYTES SHA1 output using Snowflake SHA1/standard SHA1 function
codeigniter phpexcel error ZipArchive::getFromName(): Invalid or uninitialized Zip object
How to convert a binary data into c_ubyte_Array_64 in python
socket.io socket.connected always returning false
SQL Find max no of consecutive months over a period of last 12 Months
How does Azure AD identify the Principal from a SSO AuthnRequest?
Installing Trilinos 13.0.1 with CUDA support and Clang 11.0.1-2 fails when linking Kokkoscore on Debian 11 [duplicate]
Why DLL is not imported in the python script as the other libraries?
MacOS Finder - Hidden files covering up non-hidden ones
How do I turn off the feature on my MacBook Air that highlights all texts when the mouse points to that text?