SparklineCollection
内容
[
隐藏
]SparklineCollection class
封装了一个集合Sparkline对象.
public class SparklineCollection : CollectionBase<Sparkline>
特性
| 姓名 | 描述 |
|---|---|
| Capacity { get; set; } | |
| Count { get; } | |
| Item { get; } | 获取Sparkline指定索引处的元素。 |
| Item { get; set; } |
方法
| 姓名 | 描述 |
|---|---|
| Add(string, int, int) | 添加迷你图。 |
| BinarySearch(Sparkline) | |
| BinarySearch(Sparkline, IComparer<Sparkline>) | |
| BinarySearch(int, int, Sparkline, IComparer<Sparkline>) | |
| Clear() | |
| Contains(Sparkline) | |
| CopyTo(Sparkline[]) | |
| CopyTo(Sparkline[], int) | |
| CopyTo(int, Sparkline[], int, int) | |
| Exists(Predicate<Sparkline>) | |
| Find(Predicate<Sparkline>) | |
| FindAll(Predicate<Sparkline>) | |
| FindIndex(Predicate<Sparkline>) | |
| FindIndex(int, Predicate<Sparkline>) | |
| FindIndex(int, int, Predicate<Sparkline>) | |
| FindLast(Predicate<Sparkline>) | |
| FindLastIndex(Predicate<Sparkline>) | |
| FindLastIndex(int, Predicate<Sparkline>) | |
| FindLastIndex(int, int, Predicate<Sparkline>) | |
| GetEnumerator() | |
| IndexOf(Sparkline) | |
| IndexOf(Sparkline, int) | |
| IndexOf(Sparkline, int, int) | |
| LastIndexOf(Sparkline) | |
| LastIndexOf(Sparkline, int) | |
| LastIndexOf(Sparkline, int, int) | |
| Remove(object) | 删除迷你图 |
| RemoveAt(int) |
例子
[C#]
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.SparklineGroupCollection.Add(Aspose.Cells.Charts.SparklineType.Line, sheet.Name + "!A1:D1", false, ca);
SparklineGroup group = sheet.SparklineGroupCollection[idx];
group.SparklineCollection.Add(sheet.Name + "!A1:D1", 0, 4);
book.Save("output.xlsx", SaveFormat.Xlsx);
也可以看看
- class CollectionBase<T>
- class Sparkline
- 命名空间 Aspose.Cells.Charts
- 部件 Aspose.Cells
