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 정의
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를 Aspose.Cells.Charts.Sparkline과 함께 컬렉션에 추가합니다.
public int Add(SparklineType type)매개변수
type SparklineType
Sparkline 그룹의 유형을 지정합니다.
반환 값
Aspose.Cells.Charts.SparklineGroup 객체 인덱스입니다.
Add(SparklineType, string, bool, CellArea)
Aspose.Cells.Charts.SparklineGroup를 Aspose.Cells.Charts.Sparkline과 함께 컬렉션에 추가합니다.
public int Add(SparklineType type, string dataRange, bool isVertical, CellArea locationRange)매개변수
type SparklineType
Sparkline 그룹의 유형을 지정합니다.
dataRange string
스파클라인 그룹의 데이터 범위를 지정합니다.
isVertical bool
데이터 범위에서 스파클라인을 행 또는 열로 플로팅할지를 지정합니다.
locationRange CellArea
스파클라인이 배치될 위치를 지정합니다.
반환 값
Aspose.Cells.Charts.SparklineGroup 객체 인덱스입니다.
ClearSparklineGroups(CellArea)
셀 영역과 겹치는 스파클라인 그룹을 지웁니다.
public void ClearSparklineGroups(CellArea cellArea)매개변수
cellArea CellArea
셀 영역을 지정합니다.
ClearSparklines(CellArea)
셀 영역 내의 스파클라인을 지웁니다.
public void ClearSparklines(CellArea cellArea)매개변수
cellArea CellArea
셀 영역을 지정합니다.
