Class SparklineGroupCollection

Class SparklineGroupCollection

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

Mengenkapsulasi koleksi objek Aspose.Cells.Charts.SparklineGroup.

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

Pewarisan

object ← CollectionBase<sparklinegroup> ← SparklineGroupCollection

Mengimplementasikan

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

Anggota yang Dwarisi

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

Contoh 

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

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

Properti

this[int]

Mengambil elemen Aspose.Cells.Charts.SparklineGroup pada indeks yang ditentukan.

public SparklineGroup this[int index] { get; }

Nilai Properti

SparklineGroup

Metode

Add(SparklineType)

Menambahkan Aspose.Cells.Charts.SparklineGroup dengan Aspose.Cells.Charts.Sparkline ke dalam koleksi.

public int Add(SparklineType type)

Parameter

type SparklineType

Menentukan jenis grup Sparkline.

Mengembalikan

int

Indeks objek Aspose.Cells.Charts.SparklineGroup.

Add(SparklineType, string, bool, CellArea)

Menambahkan Aspose.Cells.Charts.SparklineGroup dengan Aspose.Cells.Charts.Sparkline ke dalam koleksi.

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

Parameter

type SparklineType

Menentukan jenis grup Sparkline.

dataRange string

Menentukan rentang data dari grup sparkline.

isVertical bool

Menentukan apakah untuk memplot sparklines dari rentang data berdasarkan baris atau kolom.

locationRange CellArea

Menentukan tempat sparklines akan ditempatkan.

Mengembalikan

int

Indeks objek Aspose.Cells.Charts.SparklineGroup.

ClearSparklineGroups(CellArea)

Menghapus grup sparkline yang menumpuk area sel.

public void ClearSparklineGroups(CellArea cellArea)

Parameter

cellArea CellArea

Menentukan area sel

ClearSparklines(CellArea)

Menghapus sparklines yang berada di dalam area sel.

public void ClearSparklines(CellArea cellArea)

Parameter

cellArea CellArea

Menentukan area sel

 Indonesia