Class SparklineGroupCollection
Namespace: Aspose.Cells.Charts
Assembly: Aspose.Cells.dll (25.2.0)
Aspose.Cells.Charts.SparklineGroup nesnelerinin bir koleksiyonunu kapsar.
public class SparklineGroupCollection : CollectionBase<sparklinegroup>, IList<sparklinegroup>, ICollection<sparklinegroup>, IEnumerable<sparklinegroup>, ICollection, IEnumerable
Miras
object ← CollectionBase<sparklinegroup> ← SparklineGroupCollection
Uygulamalar
IList<sparklinegroup>, ICollection<sparklinegroup>, IEnumerable<sparklinegroup>, ICollection, IEnumerable
Miras Alınan Üyeler
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()
Örnekler
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);
// CellArea'yi tanımlayın
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);
Özellikler
this[int]
Belirtilen indeksteki Aspose.Cells.Charts.SparklineGroup öğesini alır.
public SparklineGroup this[int index] { get; }
Özellik Değeri
Metotlar
Add(SparklineType)
Bir Aspose.Cells.Charts.SparklineGroup’ü Aspose.Cells.Charts.Sparkline ile koleksiyona ekler.
public int Add(SparklineType type)
Parametreler
type
SparklineType
Sparkline grubunun türünü belirtir.
Dönüş Değeri
Aspose.Cells.Charts.SparklineGroup nesne indeksidir.
Add(SparklineType, string, bool, CellArea)
Bir Aspose.Cells.Charts.SparklineGroup’ü Aspose.Cells.Charts.Sparkline ile koleksiyona ekler.
public int Add(SparklineType type, string dataRange, bool isVertical, CellArea locationRange)
Parametreler
type
SparklineType
Sparkline grubunun türünü belirtir.
dataRange
string
Sparkline grubunun veri aralığını belirtir.
isVertical
bool
Sparklines’in veri aralığından satır veya sütun olarak çizilip çizilmeyeceğini belirtir.
locationRange
CellArea
Sparklines’in yerleştirileceği yeri belirtir.
Dönüş Değeri
Aspose.Cells.Charts.SparklineGroup nesne indeksidir.
ClearSparklineGroups(CellArea)
Bir hücre alanını kapsayan sparkline gruplarını temizler.
public void ClearSparklineGroups(CellArea cellArea)
Parametreler
cellArea
CellArea
Hücre alanını belirtir.
ClearSparklines(CellArea)
Bir hücre alanı içindeki sparklines’i temizler.
public void ClearSparklines(CellArea cellArea)
Parametreler
cellArea
CellArea
Hücre alanını belirtir.