Class SparklineGroupCollection
Contents
[
Hide
]SparklineGroupCollection class
Encapsulates a collection of SparklineGroup objects.
public class SparklineGroupCollection : CollectionBase<SparklineGroup>
Properties
| Name | Description |
|---|---|
| Capacity { get; set; } | |
| Count { get; } | |
| Item { get; } | Gets the SparklineGroup element at the specified index. |
| Item { get; set; } |
Methods
| Name | Description |
|---|---|
| Add(SparklineType) | Adds an SparklineGroup with a Sparkline to the collection. |
| Add(SparklineType, string, bool, CellArea) | Adds an SparklineGroup with Sparkline to the collection. |
| BinarySearch(SparklineGroup) | |
| BinarySearch(SparklineGroup, IComparer<SparklineGroup>) | |
| BinarySearch(int, int, SparklineGroup, IComparer<SparklineGroup>) | |
| Clear() | |
| ClearSparklineGroups(CellArea) | Clears the sparkline groups that overlaps an area of cells. |
| ClearSparklines(CellArea) | Clears the sparklines that is inside an area of cells. |
| Contains(SparklineGroup) | |
| CopyTo(SparklineGroup[]) | |
| CopyTo(SparklineGroup[], int) | |
| CopyTo(int, SparklineGroup[], int, int) | |
| Exists(Predicate<SparklineGroup>) | |
| Find(Predicate<SparklineGroup>) | |
| FindAll(Predicate<SparklineGroup>) | |
| FindIndex(Predicate<SparklineGroup>) | |
| FindIndex(int, Predicate<SparklineGroup>) | |
| FindIndex(int, int, Predicate<SparklineGroup>) | |
| FindLast(Predicate<SparklineGroup>) | |
| FindLastIndex(Predicate<SparklineGroup>) | |
| FindLastIndex(int, Predicate<SparklineGroup>) | |
| FindLastIndex(int, int, Predicate<SparklineGroup>) | |
| GetEnumerator() | |
| IndexOf(SparklineGroup) | |
| IndexOf(SparklineGroup, int) | |
| IndexOf(SparklineGroup, int, int) | |
| LastIndexOf(SparklineGroup) | |
| LastIndexOf(SparklineGroup, int) | |
| LastIndexOf(SparklineGroup, int, int) | |
| RemoveAt(int) |
Examples
[C#]
Workbook book = new Workbook();
Worksheet sheet = book.Worksheets[0];
sheet.Cells["A1"].PutValue(5);
sheet.Cells["B1"].PutValue(2);
sheet.Cells["C1"].PutValue(1);
sheet.Cells["D1"].PutValue(3);
// Define the CellArea
CellArea ca = new CellArea();
ca.StartColumn = 4;
ca.EndColumn = 4;
ca.StartRow = 0;
ca.EndRow = 0;
int idx = sheet.SparklineGroups.Add(Aspose.Cells.Charts.SparklineType.Line, "A1:D1", false, ca);
SparklineGroup group = sheet.SparklineGroups[idx];
group.Sparklines.Add(sheet.Name + "!A1:D1", 0, 4);
book.Save("output.xlsx", SaveFormat.Xlsx);
See Also
- class CollectionBase<T>
- class SparklineGroup
- namespace Aspose.Cells.Charts
- assembly Aspose.Cells
