Interface ISparklineGroups

Represents the collections of Sparkline chart group.

Inherited Members

System.Collections.Generic.IList<Syncfusion.XlsIO.ISparklineGroup>.IndexOf(Syncfusion.XlsIO.ISparklineGroup)

System.Collections.Generic.IList<Syncfusion.XlsIO.ISparklineGroup>.Insert(System.Int32, Syncfusion.XlsIO.ISparklineGroup)

System.Collections.Generic.IList<Syncfusion.XlsIO.ISparklineGroup>.RemoveAt(System.Int32)

System.Collections.Generic.IList<Syncfusion.XlsIO.ISparklineGroup>.Item[System.Int32]

System.Collections.Generic.ICollection<Syncfusion.XlsIO.ISparklineGroup>.Add(Syncfusion.XlsIO.ISparklineGroup)

System.Collections.Generic.ICollection<Syncfusion.XlsIO.ISparklineGroup>.Clear()

System.Collections.Generic.ICollection<Syncfusion.XlsIO.ISparklineGroup>.Contains(Syncfusion.XlsIO.ISparklineGroup)

System.Collections.Generic.ICollection<Syncfusion.XlsIO.ISparklineGroup>.CopyTo(Syncfusion.XlsIO.ISparklineGroup[], System.Int32)

System.Collections.Generic.ICollection<Syncfusion.XlsIO.ISparklineGroup>.Remove(Syncfusion.XlsIO.ISparklineGroup)

System.Collections.Generic.ICollection<Syncfusion.XlsIO.ISparklineGroup>.Count

System.Collections.Generic.ICollection<Syncfusion.XlsIO.ISparklineGroup>.IsReadOnly

System.Collections.Generic.IEnumerable<Syncfusion.XlsIO.ISparklineGroup>.GetEnumerator()

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.Base.dll

Syntax

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

Methods

Add()

Adds the SparklineGroup instance.

Declaration

ISparklineGroup Add()

Returns

Type	Description
ISparklineGroup	SparklineGroup instance

Examples

The follwoing is the sample for Add method

ExcelEngine engine=new ExcelEngine();

IApplication app= engine.Excel;

app.DefaultVersion= ExcelVersion.Excel2010;

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

ISparklineGroups spGroups= sheet.SparklineGroups;      

//Returns the SparklineGroup instance.
ISparklineGroup spGroup= spGroups.Add();

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

Clear(ISparklineGroup)

Clears the sparkline group.

Declaration

void Clear(ISparklineGroup sparklineGroup)

Parameters

Type	Name	Description
ISparklineGroup	sparklineGroup	The sparkline group range.

Examples

This follwing is the example for Clear Method

ExcelEngine engine=new ExcelEngine();

IApplication app= engine.Excel;

app.DefaultVersion= ExcelVersion.Excel2010;

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

ISparklineGroups spGroups= sheet.SparklineGroups;      

//Clears the SparklineGroups from the Specified range.
spGroups.Clear(spGroups[0]);

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