CODEWITHSUNDEEP
c#excel
armnotstrong
armnotstrong

Reputation: 9065

how to get cell background color of excel using C#?

I want to retrieve the background color of cell of excel using c# but I just can't find a way to do it

  1. which library shall I use ? microsoft.office.tools.excel.workbook.aspx or microsoft.office.interop.excel ? what's the differents?

  2. I have tried following code but get no luck:

    using Excel = Microsoft.Office.Interop.Excel;

private void button1_Click(object sender, EventArgs e)
{
    ofd.Filter = "xlsx|*.xlsx|xls|*.xls";

    if(ofd.ShowDialog() == DialogResult.OK)
    {
        textBox2.Text = ofd.FileName;
        Excel.Application excel = new Excel.Application();
        Excel.Workbook wb = excel.Workbooks.Open(textBox2.Text);
        Excel.Worksheet ws = wb.Sheets[1];
        Excel.Range xlRange = ws.Cells[0, 0];
        Debug.WriteLine("===" + xlRange.Interior.Color);
    }
}

Upvotes: 6

Views: 14832

Answers (4)

Aiden Or
Aiden Or

Reputation: 70

That's as simple as following:

using Excel = Microsoft.Office.Interop.Excel;
var cellColor  = sheet.Cells[rowIndex, colIndex].Style.Fill.BackgroundColor;

Upvotes: 1

Unknown
Unknown

Reputation: 153

Here's an answer that uses closed.xml. It's open-source and works with modern Excel sheets.

IXLWorkbook wb = new XLWorkbook("C:\File_path_to_excel_file"); // Replace with your file path
IXLWorksheet ws = wb.Worksheet("SheetName") // Put your sheet name here
int backgroundColor = ws.Cell(rowIndex, colIndex).Style.Fill.BackgroundColor.Color.ToArgb(); // Gives the Argb values for the cell's background. Replace rowIndex and colIndex with the index numbers of the cell you want to check

Typically an uncolored cell's Argb color is 16777215.

Upvotes: 1

Sam Sch
Sam Sch

Reputation: 672

There is nice lib called EPPlus, that makes your relationships with excel much easier. You can find it on NuGet.
So use this code to get color:

var x = sheet.Cells[rowIndex, colIndex].Style.Fill.BackgroundColor;

And this to set color:

sheet.Cells[rowIndex, colIndex].Style.Fill.SetCellsColor( Color.Yellow );

Upvotes: 6

Aousaf Rashid
Aousaf Rashid

Reputation: 5738

Easiest solution what-so-ever :

 private void Get_Colors()
  {
      Excel.Workbook excel = Globals.ThisAddIn.Application.ActiveWorkbook;
      Excel.Worksheet sheet = null;
      Excel.Range ran = sheet.UsedRange;
      for (int x = 1; x <= ran.Rows.Count; x++)
      {
          for (int y = 1; y <= ran.Columns.Count; y++)
          {
              string CellColor = sheet.Cells[x, y].Interior.Color.ToString(); //Here I go double value which is converted to string.
              if (sheet.Cells[x, y].Value != null && (CellColor == Color.Transparent.ToArgb().ToString() || **CellColor == Excel.XlRgbColor.rgbGold.GetHashCode().ToString()**))
              {
                  sheet.Cells[x, y].Interior.Color = Color.Transparent;
              }
          }
      }
  }

Upvotes: 2

Related Questions