Class SparklineGroupCollection

Class SparklineGroupCollection

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

Kapslar en samling av Aspose.Cells.Charts.SparklineGroup-objekt.

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

Arv

object ← CollectionBase<sparklinegroup> ← SparklineGroupCollection

Implementerar

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

Ärva medlemmar

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

Exempel 

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

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

Egenskaper

this[int]

Hämtar elementet Aspose.Cells.Charts.SparklineGroup vid angivet index.

public SparklineGroup this[int index] { get; }

Egenskapsvärde

SparklineGroup

Metoder

Add(SparklineType)

Lägger till en Aspose.Cells.Charts.SparklineGroup med en Aspose.Cells.Charts.Sparkline till samlingen.

public int Add(SparklineType type)

Parametrar

type SparklineType

Anger typen av Sparkline-gruppen.

Återvänder

int

Index för Aspose.Cells.Charts.SparklineGroup-objekt.

Add(SparklineType, string, bool, CellArea)

Lägger till en Aspose.Cells.Charts.SparklineGroup med Aspose.Cells.Charts.Sparkline till samlingen.

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

Parametrar

type SparklineType

Anger typen av Sparkline-gruppen.

dataRange string

Anger dataintervallet för sparkline-gruppen.

isVertical bool

Anger om sparklines ska plottas från dataintervallet radvis eller kolumnvis.

locationRange CellArea

Anger var sparklines ska placeras.

Återvänder

int

Index för Aspose.Cells.Charts.SparklineGroup-objekt.

ClearSparklineGroups(CellArea)

Rensar sparkline-grupper som överlappar ett område av celler.

public void ClearSparklineGroups(CellArea cellArea)

Parametrar

cellArea CellArea

Anger området av celler.

ClearSparklines(CellArea)

Rensar sparklines som finns inom ett område av celler.

public void ClearSparklines(CellArea cellArea)

Parametrar

cellArea CellArea

Anger området av celler.

 Svenska