How to get Cell background color using OpenXML SDK in c#

Asked Oct 07 '15 at 10:15

Active Oct 07 '15 at 10:43

Viewed 1,886 times

I want to get cell background color using OpenXML SDK in c#. Things I have done yet:

WorkbookStylesPart styles = document.WorkbookPart.WorkbookStylesPart;
Stylesheet stylesheet = styles.Stylesheet;
CellFormats cellformats = stylesheet.CellFormats;
//Fonts fonts = stylesheet.Fonts;

CellFormat f = (CellFormat)cellformats.ElementAt((int)cell.StyleIndex.Value);
Fill fill = (Fill)styles.Stylesheet.Fills.ChildElements[(int)f.FillId.Value];
fill.PatternFill.BackgroundColor = ???

what to put in RHS in above statement?

edited Jul 09 '18 at 18:41

Community

asked Oct 07 '15 at 10:15

Dev D

do you want to get the background color or set it? – DL Narasimhan Oct 07 '15 at 11:15
then I think your question mark has to be in the LHS – DL Narasimhan Oct 07 '15 at 11:21
Do u know how to set it? – Dev D Oct 07 '15 at 12:03
for you to set the color into the PatternFill Class, You could try to get it from Color.FromArgb Method from the System.Drawing Namespace – DL Narasimhan Oct 07 '15 at 12:23
are you still trying to solve this? Would getting the background color of any cell in an excel worksheet be acceptable? – Taterhead Sep 23 '16 at 14:10
You find the solution here: http://stackoverflow.com/questions/10756206/getting-cell-backgroundcolor-in-excel-with-open-xml-2-0 – Elmue May 18 '17 at 23:17

How to get Cell background color using OpenXML SDK in c#

0 Answers0