Class ExcelSparklineGroupCollection
A collection of sparkline groups
Inheritance
System.Object
ExcelSparklineGroupCollection
Implements
System.Collections.Generic.IEnumerable<ExcelSparklineGroup>
System.Collections.IEnumerable
Inherited Members
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: OfficeOpenXml.Sparkline
Assembly: EPPlus.dll
Syntax
public class ExcelSparklineGroupCollection : IEnumerable<ExcelSparklineGroup>, IEnumerableProperties
Count
Number of items in the collection
Declaration
public int Count { get; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
Item[Int32]
Returns the sparklinegroup at the specified position.
Declaration
public ExcelSparklineGroup this[int index] { get; }Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | index | The position of the Sparklinegroup. 0-base |
Property Value
| Type | Description |
|---|---|
| ExcelSparklineGroup |
Methods
Add(eSparklineType, ExcelAddressBase, ExcelAddressBase)
Adds a new sparklinegroup to the collection
Declaration
public ExcelSparklineGroup Add(eSparklineType type, ExcelAddressBase locationRange, ExcelAddressBase dataRange)Parameters
| Type | Name | Description |
|---|---|---|
| eSparklineType | type | Type of sparkline |
| ExcelAddressBase | locationRange | The location of the sparkline group. The range must have one row or column and must match the number of rows/columns in the datarange |
| ExcelAddressBase | dataRange | The data for the sparkline group |
Returns
| Type | Description |
|---|---|
| ExcelSparklineGroup |
GetEnumerator()
The enumerator for the collection
Declaration
public IEnumerator<ExcelSparklineGroup> GetEnumerator()Returns
| Type | Description |
|---|---|
| System.Collections.Generic.IEnumerator<ExcelSparklineGroup> | The enumerator |
Remove(ExcelSparklineGroup)
Removes the sparkline.
Declaration
public void Remove(ExcelSparklineGroup sparklineGroup)Parameters
| Type | Name | Description |
|---|---|---|
| ExcelSparklineGroup | sparklineGroup | The sparklinegroup to be removed |
RemoveAt(Int32)
Removes the sparkline.
Declaration
public void RemoveAt(int index)Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | index | The index of the item to be removed |
Explicit Interface Implementations
IEnumerable.GetEnumerator()
Declaration
IEnumerator IEnumerable.GetEnumerator()Returns
| Type | Description |
|---|---|
| System.Collections.IEnumerator |
Implements
System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable