Class SparklineGroupCollection

Class SparklineGroupCollection

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

Encapsula uma coleção de objetos Aspose.Cells.Charts.SparklineGroup.

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

Herança

object ← CollectionBase<sparklinegroup> ← SparklineGroupCollection

Implementa

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

Membros Herdados

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

Exemplos 

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

// Define a 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);

Propriedades

this[int]

Obtém o elemento Aspose.Cells.Charts.SparklineGroup no índice especificado.

public SparklineGroup this[int index] { get; }

Valor da Propriedade

SparklineGroup

Métodos

Add(SparklineType)

Adiciona um Aspose.Cells.Charts.SparklineGroup com um Aspose.Cells.Charts.Sparkline à coleção.

public int Add(SparklineType type)

Parâmetros

type SparklineType

Especifica o tipo do grupo de Sparkline.

Retorna

int

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

Add(SparklineType, string, bool, CellArea)

Adiciona um Aspose.Cells.Charts.SparklineGroup com Aspose.Cells.Charts.Sparkline à coleção.

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

Parâmetros

type SparklineType

Especifica o tipo do grupo de Sparkline.

dataRange string

Especifica o intervalo de dados do grupo de sparkline.

isVertical bool

Especifica se as sparklines devem ser plotadas a partir do intervalo de dados por linha ou por coluna.

locationRange CellArea

Especifica onde as sparklines devem ser colocadas.

Retorna

int

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

ClearSparklineGroups(CellArea)

Limpa os grupos de sparkline que sobrepõem uma área de células.

public void ClearSparklineGroups(CellArea cellArea)

Parâmetros

cellArea CellArea

Especifica a área de células.

ClearSparklines(CellArea)

Limpa as sparklines que estão dentro de uma área de células.

public void ClearSparklines(CellArea cellArea)

Parâmetros

cellArea CellArea

Especifica a área de células.

 Português