Class ExcelSparklineGroup

Namespace

OfficeOpenXml.Sparkline

Assembly

EPPlus.dll

Represents a group of sparklines

public class ExcelSparklineGroup : XmlHelper

Inheritance

object

XmlHelper

ExcelSparklineGroup

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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