Class SparklineCollection

Class SparklineCollection

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

Kapslar en samling av Aspose.Cells.Charts.Sparkline-objekt.

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

Arv

object ← CollectionBase<sparkline> ← SparklineCollection

Implementerar

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

Arvade medlemmar

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

Exempel

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

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

Egenskaper

this[int]

Hämtar Aspose.Cells.Charts.Sparkline-elementet vid den angivna indexen.

public Sparkline this[int index] { get; }

Egenskapsvärde

Metoder

Add(string, int, int)

Lägg till en sparkline.

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

Parametrar

dataRange string

Anger det nya dataintervallet för sparklinen.

row int

Radindex för platsen.

column int

Kolumnindex för platsen.

Återgår

Remove(object)

Tar bort sparklinen.

public void Remove(object o)

Parametrar