Hello all, I am trying to Fill multiple Excel Cells with a different unique color (See image below). I would like the cell to be colored rather than have the RGB value. Each line should have a unique color. [image] I have looked at BumbleBee but it seems to only work with conditional formatting …

Hello a solution to apply a color by row with a Python dictionary and Microsoft API # coding: utf-8 import clr clr.AddReference('ProtoGeometry') from Autodesk.DesignScript.Geometry import * import System from System import Array from System.Collections.Generic import * clr.AddReference('System.…

Have you tried xlsxwriter? Pretty powerful library: https://xlsxwriter.readthedocs.io/index.html

You are a great programmer! Tres bien! I tried to solve that, too but I could not assign RGB value to Interior.Color section. Why does not it work to pass RGB function in Python?

hello @Deniz_Maral RGB function is a function for VBA not .NET [reponse RGB Color Function]

Hello Cyril, but here under .NET you can find it or am I wrong? [image] ColorFormat Interface (Microsoft.Office.Interop.Excel) Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color. …

It’s a property not a function an example here

Merci! I did not use ForeColor.RGB… that is problem…

All, Thank you for your help and comments. A Coworker and I were able to get what we needed. @c.poupin your code was extremely helpful. The modification is not beautiful but get the job done for now and what we need. I will hopefully clean up the script in the near future. [image] [image] #ht…

Great work, thanks for sharing! I used it with my MEP system graphics and worked great

Hello, I’m trying this python script, but this is the error, any help? [image_2024_07_10T14_24_36_017Z]

This appears to be solved in your initial post. Have to tried the solution there? [image] Export Color to Excel Revit hi Switch to IronPython [image] cordially christian.stan

Excel Fill Color

Packages

Steven July 10, 2024, 5:57pm 14

This appears to be solved in your initial post. Have to tried the solution there?

Topic		Replies	Views
Excel color cells with python Developers python	6	1635	October 18, 2021
EXCEL Formatting - Bumblebee Packages archi-lab , bumblebee , excel , python	11	1147	July 6, 2022
Read Excel Cell Fill Color	2	4662	May 23, 2022
How to export output data "Excel sheet " with colorized cells excel , dynamo	7	409	January 29, 2024
Color Scheme Packages	4	800	September 20, 2016

Excel Fill Color

Related topics