Class ConditionalFormattingIconCollection

命名空间: Aspose.Cells
程序集: Aspose.Cells.dll (25.2.0)

表示 Aspose.Cells.ConditionalFormattingIcon 对象的集合。

public class ConditionalFormattingIconCollection : CollectionBase<conditionalformattingicon>, IList<conditionalformattingicon>, ICollection<conditionalformattingicon>, IEnumerable<conditionalformattingicon>, ICollection, IEnumerable

继承

object ← CollectionBase<conditionalformattingicon> ← ConditionalFormattingIconCollection

实现

IList<conditionalformattingicon>, ICollection<conditionalformattingicon>, IEnumerable<conditionalformattingicon>, ICollection, IEnumerable

继承成员

示例


// 实例化 Workbook 对象
Workbook workbook = new Workbook();

Worksheet sheet = workbook.Worksheets[0];

// 获取条件格式
ConditionalFormattingCollection cformattings = sheet.ConditionalFormattings;

// 添加一个空的条件格式
int index = cformattings.Add();

// 获取新添加的条件格式
FormatConditionCollection fcs = cformattings[index];

// 设置条件格式范围
CellArea ca = new CellArea();

ca.StartRow = 0;

ca.EndRow = 0;

ca.StartColumn = 0;

ca.EndColumn = 0;

fcs.AddArea(ca);

ca = new CellArea();

ca.StartRow = 1;

ca.EndRow = 1;

ca.StartColumn = 1;

ca.EndColumn = 1;

fcs.AddArea(ca);

// 设置条件
int idx = fcs.AddCondition(FormatConditionType.IconSet);

FormatCondition cond = fcs[idx];

// 设置条件的类型
cond.IconSet.Type = IconSetType.ArrowsGray3;

// 添加自定义图标集条件
ConditionalFormattingIcon cfIcon = cond.IconSet.CfIcons[0];

cfIcon.Type = IconSetType.Arrows3;

cfIcon.Index = 0;

ConditionalFormattingIcon cfIcon1 = cond.IconSet.CfIcons[1];

cfIcon1.Type = IconSetType.ArrowsGray3;

cfIcon1.Index = 1;

ConditionalFormattingIcon cfIcon2 = cond.IconSet.CfIcons[2];

cfIcon2.Type = IconSetType.Boxes5;

cfIcon2.Index = 2;

// 保存 Excel 文件
workbook.Save("output.xls");

' 实例化 Workbook 对象
Dim workbook As Workbook = New Workbook()

Dim sheet As Worksheet = workbook.Worksheets(0)

' 获取条件格式
Dim cformattings As ConditionalFormattingCollection = sheet.ConditionalFormattings

' 添加一个空的条件格式
Dim index As Integer = cformattings.Add()

' 获取新添加的条件格式
Dim fcs As FormatConditionCollection = cformattings(index)

' 设置条件格式范围
Dim ca As New CellArea()

ca.StartRow = 0

ca.EndRow = 0

ca.StartColumn = 0

ca.EndColumn = 0

fcs.AddArea(ca)

ca = New CellArea()

ca.StartRow = 1

ca.EndRow = 1

ca.StartColumn = 1

ca.EndColumn = 1

fcs.AddArea(ca)

' 设置条件
Dim idx As Integer = fcs.AddCondition(FormatConditionType.IconSet)

Dim cond As FormatCondition = fcs[idx]

' 设置条件的类型
cfIcon.Type = IconSetType.ArrowsGray3

' 添加自定义图标集条件
Dim cfIcon As ConditionalFormattingIcon = cond.IconSet.CfIcons[0]

cfIcon.Type = IconSetType.Arrows3

cfIcon.Index = 0

Dim cfIcon1 As ConditionalFormattingIcon = cond.IconSet.CfIcons[1]

cfIcon1.Type = IconSetType.ArrowsGray3

cfIcon1.Index = 1

Dim cfIcon2 As ConditionalFormattingIcon = cond.IconSet.CfIcons[2]

cfIcon2.Type = IconSetType.Boxes5

cfIcon2.Index = 2

' 保存 Excel 文件
workbook.Save("output.xls")

属性

this[int]

获取指定索引处的 ConditionalFormattingIcon 元素。

public ConditionalFormattingIcon this[int index] { get; }

属性值

ConditionalFormattingIcon

方法

Add(IconSetType, int)

添加 Aspose.Cells.ConditionalFormattingIcon 对象。

public int Add(IconSetType type, int index)

参数

type IconSetType

值类型。

index int

索引。

int

返回列表中新对象的索引。

Add(ConditionalFormattingIcon)

添加 Aspose.Cells.ConditionalFormattingIcon 对象。

public int Add(ConditionalFormattingIcon cficon)

参数

cficon ConditionalFormattingIcon

返回列表中新对象的索引。

int