Excel API Library for .NET - Sample Browser | Document Solutions | Create icon set rule
[
フレーム]
The icon sets rule in conditional formatting displays the icons on the basis of values entered in the cells. Each value represents a distinct icon that appears in a cell if it matches the icon sets rule applied on it. This rule can be added using the properties and methods of the IIconSetCondition interface.
//create a new workbook
var workbook = new GrapeCity.Documents.Excel.Workbook();
IWorksheet worksheet = workbook.Worksheets[0];
object[,] data = new object[,]{
{"Name", "City", "Birthday", "Eye color", "Weight", "Height"},
{"Richard", "New York", new DateTime(1968, 6, 8), "Blue", 67, 165},
{"Nia", "New York", new DateTime(1972, 7, 3), "Brown", 62, 134},
{"Jared", "New York", new DateTime(1964, 3, 2), "Hazel", 72, 180},
{"Natalie", "Washington", new DateTime(1972, 8, 8), "Blue", 66, 163},
{"Damon", "Washington", new DateTime(1986, 2, 2), "Hazel", 76, 176},
{"Angela", "Washington", new DateTime(1993, 2, 15), "Brown", 68, 145}
};
worksheet.Range["A1:F7"].Value = data;
worksheet.Columns[2].AutoFit();
//icon set rule.
IIconSetCondition condition = worksheet.Range["E2:E7"].FormatConditions.AddIconSetCondition();
condition.IconSet = workbook.IconSets[IconSetType.Icon3Symbols];
condition.IconCriteria[1].Operator = FormatConditionOperator.GreaterEqual;
condition.IconCriteria[1].Value = 30;
condition.IconCriteria[1].Type = ConditionValueTypes.Percent;
condition.IconCriteria[2].Operator = FormatConditionOperator.GreaterEqual;
condition.IconCriteria[2].Value = 70;
condition.IconCriteria[2].Type = ConditionValueTypes.Percent;
// Save to an excel file
workbook.Save("CreateIconSetRule.xlsx");
' Create a new Workbook
Dim workbook As New Workbook
Dim worksheet As IWorksheet = workbook.Worksheets(0)
Dim data As Object(,) = {
{"Name", "City", "Birthday", "Eye color", "Weight", "Height"},
{"Richard", "New York", #6/8/1968#, "Blue", 67, 165},
{"Nia", "New York", #7/3/1972#, "Brown", 62, 134},
{"Jared", "New York", #3/2/1964#, "Hazel", 72, 180},
{"Natalie", "Washington", #8/8/1972#, "Blue", 66, 163},
{"Damon", "Washington", #2/2/1986#, "Hazel", 76, 176},
{"Angela", "Washington", #2/15/1993#, "Brown", 68, 145}
}
worksheet.Range("A1:F7").Value = data
worksheet.Columns(2).AutoFit()
'icon set rule.
Dim condition As IIconSetCondition = worksheet.Range("E2:E7").FormatConditions.AddIconSetCondition()
condition.IconSet = workbook.IconSets(IconSetType.Icon3Symbols)
condition.IconCriteria(1).Operator = FormatConditionOperator.GreaterEqual
condition.IconCriteria(1).Value = 30
condition.IconCriteria(1).Type = ConditionValueTypes.Percent
condition.IconCriteria(2).Operator = FormatConditionOperator.GreaterEqual
condition.IconCriteria(2).Value = 70
condition.IconCriteria(2).Type = ConditionValueTypes.Percent
' save to an excel file
workbook.Save("CreateIconSetRule.xlsx")