Class SparklineCollection
Namespace: Aspose.Cells.Charts
Assembly: Aspose.Cells.dll (25.2.0)
รวมกลุ่มของวัตถุ Aspose.Cells.Charts.Sparkline
public class SparklineCollection : CollectionBase<sparkline>, IList<sparkline>, ICollection<sparkline>, IEnumerable<sparkline>, ICollection, IEnumerableการสืบทอด
object ← CollectionBase<sparkline> ← SparklineCollection
การนำไปใช้
IList<sparkline>, ICollection<sparkline>, IEnumerable<sparkline>, ICollection, IEnumerable
สมาชิกที่สืบทอด
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()
ตัวอย่าง
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
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);คุณสมบัติ
this[int]
รับองค์ประกอบ Aspose.Cells.Charts.Sparkline ที่ตำแหน่งดัชนีที่ระบุ
public Sparkline this[int index] { get; }ค่าของคุณสมบัติ
วิธีการ
Add(string, int, int)
เพิ่ม sparkline
public int Add(string dataRange, int row, int column)พารามิเตอร์
dataRange string
ระบุช่วงข้อมูลใหม่ของ sparkline
row int
ดัชนีแถวของตำแหน่ง
column int
ดัชนีคอลัมน์ของตำแหน่ง
คืนค่า
Remove(object)
ลบ sparkline
public void Remove(object o)พารามิเตอร์
o object
