Hi,
i setting the interior color of a cell in excel from a C# code and when i
see the result in excel the color is not matching. The color i start from is
RED and the result in the produced Excel document is BLUE.

My question is, how do i set the Color property of the interior of a cell
from a System.Drawing.Color instance... Here is what i tried...

Microsoft.Office.Interop.Excel.Range rng = sheet.Cells[Row, Col] as
Microsoft.Office.Interop.Excel.Range;
rng.Interior.Color = (interiorCellColor.Value.R << 16) |
(interiorCellColor.Value.G << 8) | interiorCellColor.Value.B;

I also tried the ToArgb method with the same result...

I will take any theory explaining the difference in color from what i start
from and the result in excel.

Remi

Ok, i think i got it:
rng.Interior.Color = (interiorCellColor.Value.B << 16) |
(interiorCellColor.Value.G << 8) | interiorCellColor.Value.R;

I think i just misplaced the values, which definitely dont make much sense
to me anyway...

Any comments ?

"(E-Mail Removed)" wrote:

> Hi,
> i setting the interior color of a cell in excel from a C# code and when i
> see the result in excel the color is not matching. The color i start from is
> RED and the result in the produced Excel document is BLUE.
>
> My question is, how do i set the Color property of the interior of a cell
> from a System.Drawing.Color instance... Here is what i tried...
>
> Microsoft.Office.Interop.Excel.Range rng = sheet.Cells[Row, Col] as
> Microsoft.Office.Interop.Excel.Range;
> rng.Interior.Color = (interiorCellColor.Value.R << 16) |
> (interiorCellColor.Value.G << 8) | interiorCellColor.Value.B;
>
> I also tried the ToArgb method with the same result...
>
> I will take any theory explaining the difference in color from what i start
> from and the result in excel.
>
> Remi