Class SparklineCollection

Class SparklineCollection

Namespace: Aspose.Cells.Charts
Assembly: Aspose.Cells.dll (25.2.0)

Zahrnuje kolekci objektů Aspose.Cells.Charts.Sparkline.

public class SparklineCollection : CollectionBase<sparkline>, IList<sparkline>, ICollection<sparkline>, IEnumerable<sparkline>, ICollection, IEnumerable

Dědění

object ← CollectionBase<sparkline> ← SparklineCollection

Implementuje

IList<sparkline>, ICollection<sparkline>, IEnumerable<sparkline>, ICollection, IEnumerable

Děděné členy

CollectionBase<sparkline>.BinarySearch(Sparkline), CollectionBase<sparkline>.BinarySearch(Sparkline, IComparer<sparkline>), CollectionBase<sparkline>.BinarySearch(int, int, Sparkline, IComparer<sparkline>), CollectionBase<sparkline>.Contains(Sparkline), CollectionBase<sparkline>.CopyTo(Sparkline[]), CollectionBase<sparkline>.CopyTo(Sparkline[], int), CollectionBase<sparkline>.CopyTo(int, Sparkline[], int, int), CollectionBase<sparkline>.Exists(Predicate<sparkline>), CollectionBase<sparkline>.Find(Predicate<sparkline>), CollectionBase<sparkline>.FindAll(Predicate<sparkline>), CollectionBase<sparkline>.FindIndex(Predicate<sparkline>), CollectionBase<sparkline>.FindIndex(int, Predicate<sparkline>), CollectionBase<sparkline>.FindIndex(int, int, Predicate<sparkline>), CollectionBase<sparkline>.FindLast(Predicate<sparkline>), CollectionBase<sparkline>.FindLastIndex(Predicate<sparkline>), CollectionBase<sparkline>.FindLastIndex(int, Predicate<sparkline>), CollectionBase<sparkline>.FindLastIndex(int, int, Predicate<sparkline>), CollectionBase<sparkline>.IndexOf(Sparkline), CollectionBase<sparkline>.IndexOf(Sparkline, int), CollectionBase<sparkline>.IndexOf(Sparkline, int, int), CollectionBase<sparkline>.LastIndexOf(Sparkline), CollectionBase<sparkline>.LastIndexOf(Sparkline, int), CollectionBase<sparkline>.LastIndexOf(Sparkline, int, int), CollectionBase<sparkline>.GetEnumerator(), CollectionBase<sparkline>.Clear(), CollectionBase<sparkline>.RemoveAt(int), CollectionBase<sparkline>.OnClearComplete(), CollectionBase<sparkline>.OnClear(), CollectionBase<sparkline>.Capacity, CollectionBase<sparkline>.Count, CollectionBase<sparkline>.InnerList, CollectionBase<sparkline>.this[int], object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Příklady

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);

// Definujte 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, sheet.Name + "!A1:D1", false, ca);
SparklineGroup group = sheet.SparklineGroups[idx];
group.Sparklines.Add(sheet.Name + "!A1:D1", 0, 4);
book.Save("output.xlsx", SaveFormat.Xlsx);

Vlastnosti

this[int]

Získá prvek Aspose.Cells.Charts.Sparkline na zadaném indexu.

public Sparkline this[int index] { get; }

Hodnota vlastnosti

Metody

Add(string, int, int)

Přidá sparkline.

public int Add(string dataRange, int row, int column)

Parametry

dataRange string

Určuje novou datovou oblast pro sparkline.

row int

Index řádku umístění.

column int

Index sloupce umístění.

Vrací

Remove(object)

Odstraní sparkline.

public void Remove(object o)

Parametry