Table of Contents

Class SparklineGroup

Namespace
Spire.Xls
Assembly
Spire.XLS.dll
public class SparklineGroup : List<ISparklines>, IList, ICollection, IReadOnlyList<ISparklines>, IReadOnlyCollection<ISparklines>, ISparklineGroup, IList<ISparklines>, ICollection<ISparklines>, IEnumerable<ISparklines>, IEnumerable
Inheritance
SparklineGroup
Implements
Inherited Members

Properties

EmptyCellsType

public SparklineEmptyCells EmptyCellsType { get; set; }

Property Value

SparklineEmptyCells

FirstPointColor

Gets and sets the color of the first point of data in the sparkline group.

public Color FirstPointColor { get; set; }

Property Value

Color

HighPointColor

Gets and sets the color of the highest points of data in the sparkline group.

public Color HighPointColor { get; set; }

Property Value

Color

HorizontalAxisColor

Gets and sets the color of the horizontal axis in the sparkline group.

public Color HorizontalAxisColor { get; set; }

Property Value

Color

HorizontalDateAxisRange

Represents the range that contains the date values for the sparkline data.

public CellRange HorizontalDateAxisRange { get; set; }

Property Value

CellRange

IsDisplayHidden

Indicates whether to show data in hidden rows and columns.

public bool IsDisplayHidden { get; set; }

Property Value

bool

IsHorizontalDateAxis

Indicates wheter represents the horizontal axis type as Dateaxis.

public bool IsHorizontalDateAxis { get; set; }

Property Value

bool

this[int]

public SparklineCollection this[int index] { get; }

Parameters

index int

Property Value

SparklineCollection

LastPointColor

Gets and sets the color of the last point of data in the sparkline group.

public Color LastPointColor { get; set; }

Property Value

Color

LineWeight

Gets and sets the line weight in each line sparkline in the sparkline group, in the unit of points.

public double LineWeight { get; set; }

Property Value

double

LowPointColor

Gets and sets the color of the lowest points of data in the sparkline group.

public Color LowPointColor { get; set; }

Property Value

Color

MarkersColor

Gets and sets the color of points in each line sparkline in the sparkline group.

public Color MarkersColor { get; set; }

Property Value

Color

NegativePointColor

Gets and sets the color of the negative values on the sparkline group.

public Color NegativePointColor { get; set; }

Property Value

Color

PlotRightToLeft

public bool PlotRightToLeft { get; set; }

Property Value

bool

ShowFirstPoint

Indicates whether to highlight the first point of data in the sparkline group.

public bool ShowFirstPoint { get; set; }

Property Value

bool

ShowHighPoint

Indicates whether to highlight the highest points of data in the sparkline group.

public bool ShowHighPoint { get; set; }

Property Value

bool

ShowHorizontalAxis

Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis.

public bool ShowHorizontalAxis { get; set; }

Property Value

bool

ShowLastPoint

Indicates whether to highlight the last point of data in the sparkline group.

public bool ShowLastPoint { get; set; }

Property Value

bool

ShowLowPoint

Indicates whether to highlight the lowest points of data in the sparkline group.

public bool ShowLowPoint { get; set; }

Property Value

bool

ShowMarkers

Indicates whether to highlight each point in each line sparkline in the sparkline group.

public bool ShowMarkers { get; set; }

Property Value

bool

ShowNegativePoint

Indicates whether to highlight the negative values on the sparkline group with a different color or marker.

public bool ShowNegativePoint { get; set; }

Property Value

bool

SparklineColor

Gets and sets the color of the sparklines in the sparkline group.

public Color SparklineColor { get; set; }

Property Value

Color

SparklineList

public SparklineCollection SparklineList { get; }

Property Value

SparklineCollection

SparklineType

Indicates the sparkline type of the sparkline group.

public SparklineType SparklineType { get; set; }

Property Value

SparklineType

VerticalAxisMaxType

Represents the vertical axis maximum value type.

public SpartlineVerticalAxisType VerticalAxisMaxType { get; set; }

Property Value

SpartlineVerticalAxisType

VerticalAxisMaxValue

Gets and sets the custom maximum value for the vertical axis.

public double VerticalAxisMaxValue { get; set; }

Property Value

double

VerticalAxisMinValue

Gets and sets the custom minimum value for the vertical axis.

public double VerticalAxisMinValue { get; set; }

Property Value

double

VerticalAxisMinValueType

Represents the vertical axis minimum value type.

public SpartlineVerticalAxisType VerticalAxisMinValueType { get; set; }

Property Value

SpartlineVerticalAxisType

Methods

Add()

public SparklineCollection Add()

Returns

SparklineCollection