Class SparklineGroups

The SparklineGroups represents the collection of SparklineGroup objects.

Inheritance

System.Object

System.Collections.Generic.List<ISparklineGroup>

SparklineGroups

Implements

System.Collections.IList

System.Collections.ICollection

System.Collections.Generic.IReadOnlyList<ISparklineGroup>

System.Collections.Generic.IReadOnlyCollection<ISparklineGroup>

ISparklineGroups

System.Collections.Generic.IList<ISparklineGroup>

System.Collections.Generic.ICollection<ISparklineGroup>

System.Collections.Generic.IEnumerable<ISparklineGroup>

System.Collections.IEnumerable

Inherited Members

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

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.AsReadOnly()

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.BinarySearch(Syncfusion.XlsIO.ISparklineGroup)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.BinarySearch(Syncfusion.XlsIO.ISparklineGroup, System.Collections.Generic.IComparer<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.BinarySearch(System.Int32, System.Int32, Syncfusion.XlsIO.ISparklineGroup, System.Collections.Generic.IComparer<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.Capacity

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

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.ConvertAll<TOutput>(System.Converter<Syncfusion.XlsIO.ISparklineGroup, TOutput>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.CopyTo(Syncfusion.XlsIO.ISparklineGroup[])

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

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

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.Exists(System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.Find(System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.FindAll(System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.FindIndex(System.Int32, System.Int32, System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.FindIndex(System.Int32, System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.FindIndex(System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.FindLast(System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.FindLastIndex(System.Int32, System.Int32, System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.FindLastIndex(System.Int32, System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.FindLastIndex(System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.ForEach(System.Action<Syncfusion.XlsIO.ISparklineGroup>)

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.GetRange(System.Int32, System.Int32)

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.IndexOf(Syncfusion.XlsIO.ISparklineGroup, System.Int32)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.IndexOf(Syncfusion.XlsIO.ISparklineGroup, System.Int32, System.Int32)

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.InsertRange(System.Int32, System.Collections.Generic.IEnumerable<Syncfusion.XlsIO.ISparklineGroup>)

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.LastIndexOf(Syncfusion.XlsIO.ISparklineGroup)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.LastIndexOf(Syncfusion.XlsIO.ISparklineGroup, System.Int32)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.LastIndexOf(Syncfusion.XlsIO.ISparklineGroup, System.Int32, System.Int32)

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.RemoveAll(System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.RemoveRange(System.Int32, System.Int32)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.Reverse()

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.Reverse(System.Int32, System.Int32)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.Sort()

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.Sort(System.Collections.Generic.IComparer<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.Sort(System.Comparison<Syncfusion.XlsIO.ISparklineGroup>)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.Sort(System.Int32, System.Int32, System.Collections.Generic.IComparer<Syncfusion.XlsIO.ISparklineGroup>)

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

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.System.Collections.ICollection.CopyTo(System.Array, System.Int32)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.System.Collections.ICollection.IsSynchronized

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.System.Collections.ICollection.SyncRoot

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.System.Collections.IList.Add(System.Object)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.System.Collections.IList.Contains(System.Object)

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

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

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.System.Collections.IList.IsFixedSize

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.System.Collections.IList.IsReadOnly

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

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.System.Collections.IList.Remove(System.Object)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.System.Collections.IList.set_Item(System.Int32, System.Object)

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.ToArray()

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.TrimExcess()

System.Collections.Generic.List<Syncfusion.XlsIO.ISparklineGroup>.TrueForAll(System.Predicate<Syncfusion.XlsIO.ISparklineGroup>)

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Syncfusion.XlsIO.Implementation

Assembly: Syncfusion.XlsIO.Base.dll

Syntax

public class SparklineGroups : List<ISparklineGroup>, IList, ICollection, IReadOnlyList<ISparklineGroup>, IReadOnlyCollection<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.IList

System.Collections.ICollection

System.Collections.Generic.IReadOnlyList<T>

System.Collections.Generic.IReadOnlyCollection<T>

ISparklineGroups

System.Collections.Generic.IList<T>

System.Collections.Generic.ICollection<T>

System.Collections.Generic.IEnumerable<T>

System.Collections.IEnumerable

Extension Methods

EnumerableExtensions.Average<TSource>(IEnumerable<TSource>, Func<TSource, Int16>)

EnumerableExtensions.Average<TSource>(IEnumerable<TSource>, Func<TSource, Nullable<Int16>>)

EnumerableExtensions.Sum<TSource>(IEnumerable<TSource>, Func<TSource, Int16>)

EnumerableExtensions.Sum<TSource>(IEnumerable<TSource>, Func<TSource, Nullable<Int16>>)

EnumerableExtensions.Max<TSource>(IEnumerable<TSource>, Func<TSource, Int16>)

EnumerableExtensions.Max<TSource>(IEnumerable<TSource>, Func<TSource, Nullable<Int16>>)

EnumerableExtensions.Min<TSource>(IEnumerable<TSource>, Func<TSource, Int16>)

EnumerableExtensions.Min<TSource>(IEnumerable<TSource>, Func<TSource, Nullable<Int16>>)

EnumerableExtensions.OrderBy<T>(IEnumerable<T>, String, Func<String, Object, Object>)

EnumerableExtensions.OrderByDescending<T>(IEnumerable<T>, String, Func<String, Object, Object>)

EnumerableExtensions.OrderBy<T>(IEnumerable<T>, String, Func<String, Object, Object>, IComparer<Object>)

EnumerableExtensions.OrderByDescending<T>(IEnumerable<T>, String, Func<String, Object, Object>, IComparer<Object>)

EnumerableExtensions.GetElementType(IEnumerable)

EnumerableExtensions.GetItemPropertyInfo(IEnumerable)

FunctionalExtensions.ForEach<T>(IEnumerable, Action<T>)

FunctionalExtensions.ForEach<T>(IEnumerable<T>, Action<T>)

FunctionalExtensions.ToList<T>(IEnumerable)

FunctionalExtensions.IterateIndex<T>(IEnumerable<T>, Action<Int32, T>)

FunctionalExtensions.IterateIndex<T>(IEnumerable<T>, Action<Int32, T>, Int32)

FunctionalExtensions.Zip<TFirst, TSecond, TResult>(IEnumerable<TFirst>, IEnumerable<TSecond>, Func<TFirst, TSecond, TResult>)

FunctionalExtensions.Fold<T, U>(IEnumerable<U>, Func<T, U, T>, T)

FunctionalExtensions.FoldLeft<T, U>(IEnumerable<U>, Func<T, U, T>, T)

FunctionalExtensions.FoldRight<T, U>(IEnumerable<U>, Func<T, U, T>, T)

FunctionalExtensions.MoveTo(IList, Int32, Int32)

FunctionalExtensions.ToObservableCollection<T>(IEnumerable<T>)

QueryableExtensions.OfQueryable(IEnumerable)

QueryableExtensions.OfQueryable(IEnumerable, Type)

QueryableExtensions.GroupByMany<TElement>(IEnumerable, Type, List<Func<TElement, Object>>)

QueryableExtensions.GroupByMany<TElement>(IEnumerable<TElement>, List<SortDescriptor>, IEnumerable<Func<TElement, Object>>)

QueryableExtensions.GroupByMany<TElement>(IEnumerable<TElement>, List<SortDescriptor>, Dictionary<String, IComparer<Object>>, String[], IEnumerable<Func<TElement, Object>>)

QueryableExtensions.GroupByMany<TElement>(IEnumerable<TElement>, List<SortDescriptor>, Dictionary<String, IComparer<Object>>, List<String>, Func<TElement, Object>[])

QueryableExtensions.GroupByMany<TElement>(IEnumerable<TElement>, List<SortDescriptor>, Func<TElement, Object>[])

QueryableExtensions.GroupByMany<TElement>(IEnumerable<TElement>, Func<TElement, Object>[])

QueryableExtensions.GroupByMany<TElement>(IEnumerable<TElement>, IEnumerable<Func<TElement, Object>>)

QueryableExtensions.GroupByMany(IEnumerable, Type, Func<String, Expression>, String[])

QueryableExtensions.GroupByMany(IEnumerable, Type, List<SortDescriptor>, Dictionary<String, IComparer<Object>>, Func<String, Expression>, String[])

QueryableExtensions.GroupByMany(IEnumerable, Type, List<SortDescriptor>, Func<String, Expression>, String[])

PivotExtension.GroupByMany<TElement>(IEnumerable<TElement>, Int32, Func<TElement, Object>[])

PivotExtension.GroupByMany<TElement>(IEnumerable<TElement>, IEnumerable<Func<TElement, Object>>)

ChartExtensionUtils.DistinctBy<TSource, TKey>(IEnumerable<TSource>, Func<TSource, TKey>)