Class SparklineGroupCollection

Class SparklineGroupCollection

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

Enkapsuluje kolekcję obiektów Aspose.Cells.Charts.SparklineGroup.

public class SparklineGroupCollection : CollectionBase<sparklinegroup>, IList<sparklinegroup>, ICollection<sparklinegroup>, IEnumerable<sparklinegroup>, ICollection, IEnumerable

Dziedziczenie

object ← CollectionBase<sparklinegroup> ← SparklineGroupCollection

Implementuje

IList<sparklinegroup>, ICollection<sparklinegroup>, IEnumerable<sparklinegroup>, ICollection, IEnumerable

Członkowie dziedziczeni

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

Przykłady 

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

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

Właściwości

this[int]

Zwraca element Aspose.Cells.Charts.SparklineGroup o podanym indeksie.

public SparklineGroup this[int index] { get; }

Wartość właściwości

SparklineGroup

Metody

Add(SparklineType)

Dodaje Aspose.Cells.Charts.SparklineGroup z Aspose.Cells.Charts.Sparkline do kolekcji.

public int Add(SparklineType type)

Parametry

type SparklineType

Określa typ grupy Sparkline.

Zwraca

int

Indeks obiektu Aspose.Cells.Charts.SparklineGroup.

Add(SparklineType, string, bool, CellArea)

Dodaje Aspose.Cells.Charts.SparklineGroup z Aspose.Cells.Charts.Sparkline do kolekcji.

public int Add(SparklineType type, string dataRange, bool isVertical, CellArea locationRange)

Parametry

type SparklineType

Określa typ grupy Sparkline.

dataRange string

Określa zakres danych grupy sparkline.

isVertical bool

Określa, czy sparklines mają być rysowane z zakresu danych wierszami czy kolumnami.

locationRange CellArea

Określa, gdzie mają być umieszczone sparklines.

Zwraca

int

Indeks obiektu Aspose.Cells.Charts.SparklineGroup.

ClearSparklineGroups(CellArea)

Czyści grupy sparkline, które zachodzą na obszar komórek.

public void ClearSparklineGroups(CellArea cellArea)

Parametry

cellArea CellArea

Określa obszar komórek.

ClearSparklines(CellArea)

Czyści sparklines, które znajdują się w obszarze komórek.

public void ClearSparklines(CellArea cellArea)

Parametry

cellArea CellArea

Określa obszar komórek.

 Polski