Excel cell color

Question

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

Rajkiran Swain · 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;

Excel cell color

Answers (2)