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>, IEnumerableMethods
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();