How to use no fill for background color of a excel cell using c#?

Question

With this: ``` using Excel = Microsoft.Office.Interop.Excel; ``` I'm opening the excel and after I'm setting the color of the first cell to transparent like this: ``` xlRange = xlWorkSheet.get_Range("A1"); xlRange.Interior.Color = System.Drawing.Color.Transparent; ``` The problem is that it puts white and the "borders" disappear. I want to put the "No Fill" option and it's not working. I've also tried this: ``` xlRange.Interior.Color = System.Drawing.Color.Empty; ``` but then it changed the cell color to black. How can I solve this?

Accepted Answer

Assuming that you want to achieve the same state as a cell's initial state (in a new worksheet), use this:

```
xlRange.Interior.ColorIndex = 0;
```

How to use no fill for background color of a excel cell using c#?

Solution

Problem