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