Class ExcelSparklineGroup¶

Namespace: OfficeOpenXml.Sparkline
Assembly: EPPlus.dll

Represents a group of sparklines

public class ExcelSparklineGroup : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelSparklineGroup

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

ColorAxis¶

Markercolor for the lowest negative point

public ExcelSparklineColor ColorAxis { get; }

Property Value¶

ExcelSparklineColor

ColorFirst¶

The color of the first point

public ExcelSparklineColor ColorFirst { get; }

Property Value¶

ExcelSparklineColor

ColorHigh¶

The color of the point with the highest value

public ExcelSparklineColor ColorHigh { get; }

Property Value¶

ExcelSparklineColor

ColorLast¶

The color of the last point

public ExcelSparklineColor ColorLast { get; }

Property Value¶

ExcelSparklineColor

ColorLow¶

The color of the point with the lowest value

public ExcelSparklineColor ColorLow { get; }

Property Value¶

ExcelSparklineColor

ColorMarkers¶

Default marker color

public ExcelSparklineColor ColorMarkers { get; }

Property Value¶

ExcelSparklineColor

ColorNegative¶

Markercolor for the lowest negative point

public ExcelSparklineColor ColorNegative { get; }

Property Value¶

ExcelSparklineColor

ColorSeries¶

Sparkline color

public ExcelSparklineColor ColorSeries { get; }

Property Value¶

ExcelSparklineColor

DataRange¶

The range containing the data from the sparklines

public ExcelRangeBase DataRange { get; }

Property Value¶

ExcelRangeBase

DateAxisRange¶

The range containing the dateaxis from the sparklines. Set to Null to remove the dateaxis.

public ExcelRangeBase DateAxisRange { get; set; }

Property Value¶

ExcelRangeBase

DisplayEmptyCellsAs¶

How to display empty cells in the series

public eDispBlanksAs DisplayEmptyCellsAs { get; set; }

Property Value¶

eDispBlanksAs

DisplayHidden¶

Display hidden cells

public bool DisplayHidden { get; set; }

Property Value¶

bool

DisplayXAxis¶

Displays the X axis

public bool DisplayXAxis { get; set; }

Property Value¶

bool

First¶

Highlight the first point of data in the sparkline group

public bool First { get; set; }

Property Value¶

bool

High¶

Highlight the highest point of data in the sparkline group

public bool High { get; set; }

Property Value¶

bool

Last¶

Highlight the last point of data in the sparkline group

public bool Last { get; set; }

Property Value¶

bool

LineWidth¶

The weight of the line. Applies to line sparklines only.

public double LineWidth { get; set; }

Property Value¶

double

LocationRange¶

The range containing the sparklines

public ExcelRangeBase LocationRange { get; }

Property Value¶

ExcelRangeBase

Low¶

Highlight the lowest point of data in the sparkline group

public bool Low { get; set; }

Property Value¶

bool

ManualMax¶

When MaxAxisType type is set to Custom, this value sets the maximum value MaxAxisType

public double ManualMax { get; set; }

Property Value¶

double

ManualMin¶

When MinAxisType type is set to Custom, this value sets the minimum value MinAxisType

public double ManualMin { get; set; }

Property Value¶

double

Markers¶

Highlight each point in each sparkline in the sparkline group. Applies to line sparklines only

public bool Markers { get; set; }

Property Value¶

bool

MaxAxisType¶

Vertical axis maximum value options

public eSparklineAxisMinMax MaxAxisType { get; set; }

Property Value¶

eSparklineAxisMinMax

MinAxisType¶

Vertical axis minimum value options

public eSparklineAxisMinMax MinAxisType { get; set; }

Property Value¶

eSparklineAxisMinMax

Negative¶

Highlight negative points of data in the sparkline group with a different color or marker

public bool Negative { get; set; }

Property Value¶

bool

RightToLeft¶

Plot horizontal axis data right to left if true

public bool RightToLeft { get; set; }

Property Value¶

bool

Sparklines¶

The Sparklines for the sparklinegroup

public ExcelSparklineCollection Sparklines { get; }

Property Value¶

ExcelSparklineCollection

Type¶

Type of sparkline

public eSparklineType Type { get; set; }

Property Value¶

eSparklineType