Class SparklineGroupCollection
Namespace: Aspose.Cells.Charts
Assembly: Aspose.Cells.dll (25.2.0)
يحتوي على مجموعة من كائنات Aspose.Cells.Charts.SparklineGroup.
public class SparklineGroupCollection : CollectionBase<sparklinegroup>, IList<sparklinegroup>, ICollection<sparklinegroup>, IEnumerable<sparklinegroup>, ICollection, IEnumerableالوراثة
object ← CollectionBase<sparklinegroup> ← SparklineGroupCollection
ينفذ
IList<sparklinegroup>, ICollection<sparklinegroup>, IEnumerable<sparklinegroup>, ICollection, IEnumerable
الأعضاء الموروثون
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()
أمثلة
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 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);الخصائص
this[int]
يحصل على عنصر Aspose.Cells.Charts.SparklineGroup في الفهرس المحدد.
public SparklineGroup this[int index] { get; }قيمة الخاصية
الطرق
Add(SparklineType)
يضيف مجموعة Aspose.Cells.Charts.SparklineGroup مع Sparkline من Aspose.Cells.Charts إلى المجموعة.
public int Add(SparklineType type)المعلمات
type SparklineType
يحدد نوع مجموعة Sparkline.
العائدات
فهرس كائن Aspose.Cells.Charts.SparklineGroup.
Add(SparklineType, string, bool, CellArea)
يضيف مجموعة Aspose.Cells.Charts.SparklineGroup مع Sparkline من Aspose.Cells.Charts إلى المجموعة.
public int Add(SparklineType type, string dataRange, bool isVertical, CellArea locationRange)المعلمات
type SparklineType
يحدد نوع مجموعة Sparkline.
dataRange string
يحدد نطاق البيانات لمجموعة Sparkline.
isVertical bool
يحدد ما إذا كان سيتم رسم Sparkline من نطاق البيانات حسب الصف أو العمود.
locationRange CellArea
يحدد مكان وضع Sparkline.
العائدات
فهرس كائن Aspose.Cells.Charts.SparklineGroup.
ClearSparklineGroups(CellArea)
يمسح مجموعات Sparkline التي تتداخل مع منطقة من الخلايا.
public void ClearSparklineGroups(CellArea cellArea)المعلمات
cellArea CellArea
يحدد منطقة الخلايا.
ClearSparklines(CellArea)
يمسح Sparkline الموجودة داخل منطقة من الخلايا.
public void ClearSparklines(CellArea cellArea)المعلمات
cellArea CellArea
يحدد منطقة الخلايا.
