Class SparklineCollection
Namespace: Aspose.Cells.Charts
Assembly: Aspose.Cells.dll (25.2.0)
Mengenkapsulasi koleksi objek Aspose.Cells.Charts.Sparkline.
public class SparklineCollection : CollectionBase<sparkline>, IList<sparkline>, ICollection<sparkline>, IEnumerable<sparkline>, ICollection, IEnumerable
Pewarisan
object ← CollectionBase<sparkline> ← SparklineCollection
Mengimplementasikan
IList<sparkline>, ICollection<sparkline>, IEnumerable<sparkline>, ICollection, IEnumerable
Anggota yang Dwarisi
CollectionBase<sparkline>.BinarySearch(Sparkline), CollectionBase<sparkline>.BinarySearch(Sparkline, IComparer<sparkline>), CollectionBase<sparkline>.BinarySearch(int, int, Sparkline, IComparer<sparkline>), CollectionBase<sparkline>.Contains(Sparkline), CollectionBase<sparkline>.CopyTo(Sparkline[]), CollectionBase<sparkline>.CopyTo(Sparkline[], int), CollectionBase<sparkline>.CopyTo(int, Sparkline[], int, int), CollectionBase<sparkline>.Exists(Predicate<sparkline>), CollectionBase<sparkline>.Find(Predicate<sparkline>), CollectionBase<sparkline>.FindAll(Predicate<sparkline>), CollectionBase<sparkline>.FindIndex(Predicate<sparkline>), CollectionBase<sparkline>.FindIndex(int, Predicate<sparkline>), CollectionBase<sparkline>.FindIndex(int, int, Predicate<sparkline>), CollectionBase<sparkline>.FindLast(Predicate<sparkline>), CollectionBase<sparkline>.FindLastIndex(Predicate<sparkline>), CollectionBase<sparkline>.FindLastIndex(int, Predicate<sparkline>), CollectionBase<sparkline>.FindLastIndex(int, int, Predicate<sparkline>), CollectionBase<sparkline>.IndexOf(Sparkline), CollectionBase<sparkline>.IndexOf(Sparkline, int), CollectionBase<sparkline>.IndexOf(Sparkline, int, int), CollectionBase<sparkline>.LastIndexOf(Sparkline), CollectionBase<sparkline>.LastIndexOf(Sparkline, int), CollectionBase<sparkline>.LastIndexOf(Sparkline, int, int), CollectionBase<sparkline>.GetEnumerator(), CollectionBase<sparkline>.Clear(), CollectionBase<sparkline>.RemoveAt(int), CollectionBase<sparkline>.OnClearComplete(), CollectionBase<sparkline>.OnClear(), CollectionBase<sparkline>.Capacity, CollectionBase<sparkline>.Count, CollectionBase<sparkline>.InnerList, CollectionBase<sparkline>.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, sheet.Name + "!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]
Mendapatkan elemen Aspose.Cells.Charts.Sparkline pada indeks yang ditentukan.
public Sparkline this[int index] { get; }
Nilai Properti
Metode
Add(string, int, int)
Menambahkan sebuah sparkline.
public int Add(string dataRange, int row, int column)
Parameter
dataRange
string
Menentukan rentang data baru dari sparkline.
row
int
Indeks baris dari lokasi.
column
int
Indeks kolom dari lokasi.
Mengembalikan
Remove(object)
Menghapus sparkline.
public void Remove(object o)
Parameter
o
object