Class SparklineGroups

The SparklineGroups represents the collection of SparklineGroup objects.

Inheritance
System.Object
SparklineGroups
Implements
System.Collections.Generic.IList<ISparklineGroup>
System.Collections.Generic.ICollection<ISparklineGroup>
System.Collections.Generic.IEnumerable<ISparklineGroup>
System.Collections.IEnumerable
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
public class SparklineGroups : List<ISparklineGroup>, ISparklineGroups, IList<ISparklineGroup>, ICollection<ISparklineGroup>, IEnumerable<ISparklineGroup>, IEnumerable

Constructors

SparklineGroups(WorkbookImpl)

Represnts the implementaion of SparklineGroups

Declaration
public SparklineGroups(WorkbookImpl book)
Parameters
Type Name Description
WorkbookImpl book

Methods

Add()

Adds the SparklineGroup instance.

Declaration
public 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
public void Clear(ISparklineGroup sparklineGroup)
Parameters
Type Name Description
ISparklineGroup sparklineGroup
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] as ISparklineGroup);

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

Implements

System.Collections.Generic.IList<>
System.Collections.Generic.ICollection<>
System.Collections.Generic.IEnumerable<>
System.Collections.IEnumerable