Interface ISparklineGroup

Represents the Sparkline chart group.

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.NET.dll

Syntax

public interface ISparklineGroup : IList<ISparklines>, ICollection<ISparklines>, IEnumerable<ISparklines>, IEnumerable

Properties

AxisColor

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

Declaration

Color AxisColor { get; set; }

Property Value

Type	Description
Color	The color of the axis.

DisplayAxis

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

Declaration

bool DisplayAxis { get; set; }

Property Value

Type	Description
System.Boolean	`true` if [display axis]; otherwise, `false`.

DisplayEmptyCellsAs

Indicates how to display empty cells.

Declaration

SparklineEmptyCells DisplayEmptyCellsAs { get; set; }

Property Value

Type	Description
SparklineEmptyCells	The DisplayEmptyCellsAs property gets/sets the m_displayEmptyCellsAs data member.

DisplayHiddenRC

Indicates whether to show data in hidden rows and columns.

Declaration

bool DisplayHiddenRC { get; set; }

Property Value

Type	Description
System.Boolean	`true` if [display hidden RC]; otherwise, `false`.

FirstPointColor

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

Declaration

Color FirstPointColor { get; set; }

Property Value

Type	Description
Color	The first color of the point.

HighPointColor

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

Declaration

Color HighPointColor { get; set; }

Property Value

Type	Description
Color	The color of the high point.

HorizontalDateAxis

The HorizontalDateAxis property represents the horizontal axis type as Dateaxis.

Declaration

bool HorizontalDateAxis { get; set; }

Property Value

Type	Description
System.Boolean	`true` if [horizontal date axis]; otherwise, `false`.

HorizontalDateAxisRange

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

Declaration

IRange HorizontalDateAxisRange { get; set; }

Property Value

Type	Description
IRange	The HorizontalDateAxisRange property gets/sets the m_horizontalDateAxisRange data member.

Exceptions

Type	Condition
System.ArgumentOutOfRangeException	if`Value.Rows.Length.Rows.Length`is not equal to 1 if`value.Column.Length.Column.Length`is not equal to 1 if`HorizontalDateAxis`is not true

LastPointColor

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

Declaration

Color LastPointColor { get; set; }

Property Value

Type	Description
Color	The last color of the point.

LineWeight

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

Declaration

double LineWeight { get; set; }

Property Value

Type	Description
System.Double	The line weight value should be between 0 and 1584.

Exceptions

Type	Condition
System.ArgumentOutOfRangeException	if the value is not between 0 and 1584

LowPointColor

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

Declaration

Color LowPointColor { get; set; }

Property Value

Type	Description
Color	The color of the low point.

MarkersColor

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

Declaration

Color MarkersColor { get; set; }

Property Value

Type	Description
Color	The color of the markers.

NegativePointColor

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

Declaration

Color NegativePointColor { get; set; }

Property Value

Type	Description
Color	The color of the negative point.

PlotRightToLeft

Indicates whether the plot data is right to left.

Declaration

bool PlotRightToLeft { get; set; }

Property Value

Type	Description
System.Boolean	`true` if [plot right to left]; otherwise, `false`.

ShowFirstPoint

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

Declaration

bool ShowFirstPoint { get; set; }

Property Value

Type	Description
System.Boolean	`true` if [show first point]; otherwise, `false`.

ShowHighPoint

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

Declaration

bool ShowHighPoint { get; set; }

Property Value

Type	Description
System.Boolean	`true` if [show high point]; otherwise, `false`.

ShowLastPoint

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

Declaration

bool ShowLastPoint { get; set; }

Property Value

Type	Description
System.Boolean	`true` if [show last point]; otherwise, `false`.

ShowLowPoint

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

Declaration

bool ShowLowPoint { get; set; }

Property Value

Type	Description
System.Boolean	`true` if [show low point]; otherwise, `false`.

ShowMarkers

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

Declaration

bool ShowMarkers { get; set; }

Property Value

Type	Description
System.Boolean	`true` if [show markers]; otherwise, `false`.

Exceptions

Type	Condition
System.NotSupportedException	If Sparklinetype is not equal to Line

ShowNegativePoint

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

Declaration

bool ShowNegativePoint { get; set; }

Property Value

Type	Description
System.Boolean	`true` if [show negative point]; otherwise, `false`.

SparklineColor

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

Declaration

Color SparklineColor { get; set; }

Property Value

Type	Description
Color	The color of the sparkline.

SparklineType

Indicates the sparkline type of the sparkline group.

Declaration

SparklineType SparklineType { get; set; }

Property Value

Type	Description
SparklineType	The SparklineType property gets/sets the m_sparklineType member.

VerticalAxisMaximum

The VerticalAxisMaximum property represents the Vertical Axis maximum options.

Declaration

ISparklineVerticalAxis VerticalAxisMaximum { get; set; }

Property Value

Type	Description
ISparklineVerticalAxis	The VerticalAxisMaximum property gets/sets the m_verticalMaximum member.

VerticalAxisMinimum

The VerticalAxisMinimum property represents the Vertical Axis minimum options.

Declaration

ISparklineVerticalAxis VerticalAxisMinimum { get; set; }

Property Value

Type	Description
ISparklineVerticalAxis	The VerticalAxisMinimum property gets/sets the m_verticalMinimum member.

Methods

Add()

Adds Sparklines instance.

Declaration

ISparklines Add()

Returns

Type	Description
ISparklines	Sparklines object

Examples

This Example Demostrated how to Add the Sparklines

ExcelEngine engine=new ExcelEngine();

IApplication app= engine.Excel;

app.DefaultVersion= ExcelVersion.Excel2010;

IWorkbook wkBook= app.Workbooks.Create(2); 
IWorksheet sheet= wkBook.Worksheets[0];

ISparklineGroup spGroup= sheet.SparklineGroups.Add();        

//It returns the Sparklines object
ISparklines spLines= spGroup.Add();

wkBook.SaveAs("Sample.xlsx");
wkBook.Close();