Class SparklineGroupCollection

Class SparklineGroupCollection

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

Zabaluje kolekci objektů Aspose.Cells.Charts.SparklineGroup.

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

Dědění

object ← CollectionBase<sparklinegroup> ← SparklineGroupCollection

Implementuje

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

Děděné členy

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

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, "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.SparklineGroup na zadaném indexu.

public SparklineGroup this[int index] { get; }

Hodnota vlastnosti

SparklineGroup

Metody

Add(SparklineType)

Přidá Aspose.Cells.Charts.SparklineGroup s Aspose.Cells.Charts.Sparkline do kolekce.

public int Add(SparklineType type)

Parametry

type SparklineType

Specifikuje typ skupiny Sparkline.

Vrací

int

Index objektu Aspose.Cells.Charts.SparklineGroup.

Add(SparklineType, string, bool, CellArea)

Přidá Aspose.Cells.Charts.SparklineGroup s Aspose.Cells.Charts.Sparkline do kolekce.

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

Parametry

type SparklineType

Specifikuje typ skupiny Sparkline.

dataRange string

Specifikuje datový rozsah skupiny sparkline.

isVertical bool

Specifikuje, zda se mají sparklines vykreslovat z datového rozsahu podle řádku nebo podle sloupce.

locationRange CellArea

Specifikuje, kde mají být sparklines umístěny.

Vrací

int

Index objektu Aspose.Cells.Charts.SparklineGroup.

ClearSparklineGroups(CellArea)

Vymaže skupiny sparklines, které se překrývají s oblastí buněk.

public void ClearSparklineGroups(CellArea cellArea)

Parametry

cellArea CellArea

Specifikuje oblast buněk.

ClearSparklines(CellArea)

Vymaže sparklines, které jsou uvnitř oblasti buněk.

public void ClearSparklines(CellArea cellArea)

Parametry

cellArea CellArea

Specifikuje oblast buněk.

 Čeština