internal void FromColorScale(X14.ColorScale cs) { SetAllNull(); SLConditionalFormattingValueObject2010 cfvo; SLColor clr; using (var oxr = OpenXmlReader.Create(cs)) { while (oxr.Read()) { if (oxr.ElementType == typeof(X14.ConditionalFormattingValueObject)) { cfvo = new SLConditionalFormattingValueObject2010(); cfvo.FromConditionalFormattingValueObject( (X14.ConditionalFormattingValueObject)oxr.LoadCurrentElement()); Cfvos.Add(cfvo); } else if (oxr.ElementType == typeof(X14.Color)) { clr = new SLColor(new List <Color>(), new List <Color>()); clr.FromExcel2010Color((X14.Color)oxr.LoadCurrentElement()); Colors.Add(clr); } } } }
internal X14.ColorScale ToColorScale() { X14.ColorScale cs = new X14.ColorScale(); foreach (SLConditionalFormattingValueObject2010 cfvo in this.Cfvos) { cs.Append(cfvo.ToConditionalFormattingValueObject()); } foreach (SLColor clr in this.Colors) { cs.Append(clr.ToExcel2010Color()); } return cs; }
internal X14.ColorScale ToColorScale() { X14.ColorScale cs = new X14.ColorScale(); foreach (SLConditionalFormattingValueObject2010 cfvo in this.Cfvos) { cs.Append(cfvo.ToConditionalFormattingValueObject()); } foreach (SLColor clr in this.Colors) { cs.Append(clr.ToExcel2010Color()); } return(cs); }