GrapeCity.Documents.Excel.IIconCriteria.Item

this Property

this[int]

Gets an IIconCriterion object from the collection.

Each returned criterion represents the threshold settings for one icon in an icon set conditional formatting rule.

Declaration

IIconCriterion this[int Index] { get; }

ReadOnly Default Property Item(Index As Integer) As IIconCriterion

Parameters

Type	Name	Description
int	Index	The zero-based index of the icon criterion. The valid range is `0` through `Count - 1`. An index outside this range is invalid and causes an IndexOutOfRangeException when the criterion is accessed.

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {30}, {50}, {70}, {90}};
IIconSetCondition condition = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
condition.IconSet = workbook.IconSets[IconSetType.Icon3Symbols];
IIconCriterion criterion = condition.IconCriteria[1];