Class SparklineGroupCollection

Class SparklineGroupCollection

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

Incapsula una collezione di oggetti Aspose.Cells.Charts.SparklineGroup.

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

Ereditarietà

object ← CollectionBase<sparklinegroup> ← SparklineGroupCollection

Implementa

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

Membri Ereditati

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

Esempi 

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

// Definisci l'area della cella
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);

Proprietà

this[int]

Ottiene l’elemento Aspose.Cells.Charts.SparklineGroup all’indice specificato.

public SparklineGroup this[int index] { get; }

Valore della Proprietà

SparklineGroup

Metodi

Add(SparklineType)

Aggiunge un Aspose.Cells.Charts.SparklineGroup con un Aspose.Cells.Charts.Sparkline alla collezione.

public int Add(SparklineType type)

Parametri

type SparklineType

Specifica il tipo del gruppo Sparkline.

Restituisce

int

Indice dell’oggetto Aspose.Cells.Charts.SparklineGroup.

Add(SparklineType, string, bool, CellArea)

Aggiunge un Aspose.Cells.Charts.SparklineGroup con Aspose.Cells.Charts.Sparkline alla collezione.

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

Parametri

type SparklineType

Specifica il tipo del gruppo Sparkline.

dataRange string

Specifica l’intervallo di dati del gruppo sparkline.

isVertical bool

Specifica se tracciare le sparklines dall’intervallo di dati per riga o per colonna.

locationRange CellArea

Specifica dove devono essere posizionate le sparklines.

Restituisce

int

Indice dell’oggetto Aspose.Cells.Charts.SparklineGroup.

ClearSparklineGroups(CellArea)

Pulisce i gruppi sparkline che sovrappongono un’area di celle.

public void ClearSparklineGroups(CellArea cellArea)

Parametri

cellArea CellArea

Specifica l’area delle celle.

ClearSparklines(CellArea)

Pulisce le sparklines che si trovano all’interno di un’area di celle.

public void ClearSparklines(CellArea cellArea)

Parametri

cellArea CellArea

Specifica l’area delle celle.

 Italiano