Excel cell color

Question

Hi, I need a code to read the excel cell background color using open xml  Thanks

Rajkiran Swain · Accepted Answer

SpreadsheetDocument doc = SpreadsheetDocument.Open( "1.xlsx" ,  true );   Sheet sheet = (Sheet)doc.WorkbookPart.Workbook.Sheets.FirstOrDefault();   WorksheetPart worksheetPart = (WorksheetPart)doc.WorkbookPart                                                   .GetPartById(sheet.Id);   Worksheet worksheet = worksheetPart.Worksheet;      WorkbookStylesPart styles = doc.WorkbookPart.WorkbookStylesPart;   Stylesheet stylesheet = styles.Stylesheet;   CellFormats cellformats = stylesheet.CellFormats;   Fonts fonts = stylesheet.Fonts;      UInt32 fontIndex = fonts.Count;   UInt32 formatIndex = cellformats.Count;      Cell cell = GetCell(worksheet,  "A" , 19);   cell.CellValue =  new  CellValue(DateTime.Now.ToLongTimeString());   cell.DataType =  new  EnumValue (CellValues.String);      CellFormat f = (CellFormat)cellformats.ElementAt(( int )cell.StyleIndex.Value);      var font = (Font)fonts.ElementAt(( int )f.FontId.Value);   var newfont = (Font)font.Clone();   newfont.Color =  new  Color() { Rgb =  new  HexBinaryValue( "ff0000" ) };   fonts.Append(newfont);      CellFormat newformat = (CellFormat)f.Clone();   newformat.FontId = fontIndex;   cellformats.Append(newformat);      stylesheet.Save();      cell.StyleIndex = formatIndex;   doc.Close();

Leon D · Answer

Hi John,    You can use free spire.xls dll from nuget to read the cell background color. Below code for your reference: Workbook workbook =  new  Workbook();   workbook.LoadFromFile(@ "Input.xlsx" );      Worksheet sheet = workbook.Worksheets[0];      Color backColor = sheet.Range[ "A1" ].Style.Color;