Interface ISparklineGroup
Represents the Sparkline chart group.
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.UWP.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 |
---|---|
Windows.UI.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 |
|
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 |
|
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 |
---|---|
Windows.UI.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 |
---|---|
Windows.UI.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 |
|
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 |
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 |
---|---|
Windows.UI.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 |
---|---|
Windows.UI.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 |
---|---|
Windows.UI.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 |
---|---|
Windows.UI.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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
SparklineColor
Gets and sets the color of the sparklines in the sparkline group.
Declaration
Color SparklineColor { get; set; }
Property Value
Type | Description |
---|---|
Windows.UI.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();