Class SparklineGroupCollection

Class SparklineGroupCollection

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

Encapsula una colección de objetos Aspose.Cells.Charts.SparklineGroup.

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

Herencia

object ← CollectionBase<sparklinegroup> ← SparklineGroupCollection

Implementa

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

Miembros heredados

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

Ejemplos 

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

// Definir el 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);

Propiedades

this[int]

Obtiene el elemento Aspose.Cells.Charts.SparklineGroup en el índice especificado.

public SparklineGroup this[int index] { get; }

Valor de la propiedad

SparklineGroup

Métodos

Add(SparklineType)

Agrega un Aspose.Cells.Charts.SparklineGroup con un Aspose.Cells.Charts.Sparkline a la colección.

public int Add(SparklineType type)

Parámetros

type SparklineType

Especifica el tipo del grupo de Sparkline.

Retorna

int

Índice del objeto Aspose.Cells.Charts.SparklineGroup.

Add(SparklineType, string, bool, CellArea)

Agrega un Aspose.Cells.Charts.SparklineGroup con Aspose.Cells.Charts.Sparkline a la colección.

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

Parámetros

type SparklineType

Especifica el tipo del grupo de Sparkline.

dataRange string

Especifica el rango de datos del grupo de sparkline.

isVertical bool

Especifica si se deben trazar las sparklines desde el rango de datos por fila o por columna.

locationRange CellArea

Especifica dónde se colocarán las sparklines.

Retorna

int

Índice del objeto Aspose.Cells.Charts.SparklineGroup.

ClearSparklineGroups(CellArea)

Limpia los grupos de sparkline que se superponen a un área de celdas.

public void ClearSparklineGroups(CellArea cellArea)

Parámetros

cellArea CellArea

Especifica el área de celdas.

ClearSparklines(CellArea)

Limpia las sparklines que están dentro de un área de celdas.

public void ClearSparklines(CellArea cellArea)

Parámetros

cellArea CellArea

Especifica el área de celdas.

 Español