Show / Hide Table of Contents

Class ExcelSparklineGroup

Represents a group of sparklines

Inheritance
System.Object
XmlHelper
ExcelSparklineGroup
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Sparkline
Assembly: EPPlus.dll
Syntax
public class ExcelSparklineGroup : XmlHelper

Properties

ColorAxis

Markercolor for the lowest negative point

Declaration
public ExcelSparklineColor ColorAxis { get; }
Property Value
Type Description
ExcelSparklineColor

ColorFirst

The color of the first point

Declaration
public ExcelSparklineColor ColorFirst { get; }
Property Value
Type Description
ExcelSparklineColor

ColorHigh

The color of the point with the highest value

Declaration
public ExcelSparklineColor ColorHigh { get; }
Property Value
Type Description
ExcelSparklineColor

ColorLast

The color of the last point

Declaration
public ExcelSparklineColor ColorLast { get; }
Property Value
Type Description
ExcelSparklineColor

ColorLow

The color of the point with the lowest value

Declaration
public ExcelSparklineColor ColorLow { get; }
Property Value
Type Description
ExcelSparklineColor

ColorMarkers

Default marker color

Declaration
public ExcelSparklineColor ColorMarkers { get; }
Property Value
Type Description
ExcelSparklineColor

ColorNegative

Markercolor for the lowest negative point

Declaration
public ExcelSparklineColor ColorNegative { get; }
Property Value
Type Description
ExcelSparklineColor

ColorSeries

Sparkline color

Declaration
public ExcelSparklineColor ColorSeries { get; }
Property Value
Type Description
ExcelSparklineColor

DataRange

The range containing the data from the sparklines

Declaration
public ExcelRangeBase DataRange { get; }
Property Value
Type Description
ExcelRangeBase

DateAxisRange

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

Declaration
public ExcelRangeBase DateAxisRange { get; set; }
Property Value
Type Description
ExcelRangeBase

DisplayEmptyCellsAs

How to display empty cells in the series

Declaration
public eDispBlanksAs DisplayEmptyCellsAs { get; set; }
Property Value
Type Description
eDispBlanksAs

DisplayHidden

Display hidden cells

Declaration
public bool DisplayHidden { get; set; }
Property Value
Type Description
System.Boolean

DisplayXAxis

Displays the X axis

Declaration
public bool DisplayXAxis { get; set; }
Property Value
Type Description
System.Boolean

First

Highlight the first point of data in the sparkline group

Declaration
public bool First { get; set; }
Property Value
Type Description
System.Boolean

High

Highlight the highest point of data in the sparkline group

Declaration
public bool High { get; set; }
Property Value
Type Description
System.Boolean

Last

Highlight the last point of data in the sparkline group

Declaration
public bool Last { get; set; }
Property Value
Type Description
System.Boolean

LineWidth

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

Declaration
public double LineWidth { get; set; }
Property Value
Type Description
System.Double

LocationRange

The range containing the sparklines

Declaration
public ExcelRangeBase LocationRange { get; }
Property Value
Type Description
ExcelRangeBase

Low

Highlight the lowest point of data in the sparkline group

Declaration
public bool Low { get; set; }
Property Value
Type Description
System.Boolean

ManualMax

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

Declaration
public double ManualMax { get; set; }
Property Value
Type Description
System.Double

ManualMin

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

Declaration
public double ManualMin { get; set; }
Property Value
Type Description
System.Double

Markers

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

Declaration
public bool Markers { get; set; }
Property Value
Type Description
System.Boolean

MaxAxisType

Vertical axis maximum value options

Declaration
public eSparklineAxisMinMax MaxAxisType { get; set; }
Property Value
Type Description
eSparklineAxisMinMax

MinAxisType

Vertical axis minimum value options

Declaration
public eSparklineAxisMinMax MinAxisType { get; set; }
Property Value
Type Description
eSparklineAxisMinMax

Negative

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

Declaration
public bool Negative { get; set; }
Property Value
Type Description
System.Boolean

RightToLeft

Plot horizontal axis data right to left if true

Declaration
public bool RightToLeft { get; set; }
Property Value
Type Description
System.Boolean

Sparklines

The Sparklines for the sparklinegroup

Declaration
public ExcelSparklineCollection Sparklines { get; }
Property Value
Type Description
ExcelSparklineCollection

Type

Type of sparkline

Declaration
public eSparklineType Type { get; set; }
Property Value
Type Description
eSparklineType
Back to top Generated by DocFX