Setting Excel Cell Colours using RGB Values

c# .net excel-interop
SBozhko picture SBozhko · Jul 26, 2017 · Viewed 9k times · Source

I'm trying to set Excel cells using RGB values rather than the way I do it currently as i need to set cells to a specific colour rather than a set standard colour.

This is how i currently do it:

ChartRange.Interior.Color = Microsoft.Office.Interop.Excel.XlRgbColor.rgbRed;

Is it possible to set colour in RGB values in C#?

I am working with Excel sheets that have had the colours set by RGB values in VBA.

Answer

Balagurunathan Marimuthu picture Balagurunathan Marimuthu · Jul 26, 2017

You can able to assign the System.Drawing.Color using FromArgb as below:

ChartRange.Interior.Color = System.Drawing.Color.FromArgb(255, 0, 0);

Related questions

Class not registered error when creating Excel workbook in C#

When I try to access an Excel spreadsheet using the following code I get a "Library not registered' error when defining the workbook object wrkbuk using C# from Visual Studio 2012 with Office 2007 (ver 12) installed Microsoft.Office.Interop.Excel.Application excapp = …

Read More
Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX) for System.Runtime.InteropServices.COMException

I have a part of code which tries to export data (from database) to Excel. When I am trying to perform this task, it is generating this error: System.Runtime.InteropServices.COMException occurred Additional information: Invalid index. (Exception from HRESULT: 0…

Read More
How to rename excel sheet name dynamically in C#

I have created an excel workbook with many sheets like sheet1, sheet2,... etc. How can I rename these tab names dynamically in C#?

Read More