[]
IIconSet 通过其 IconSetType 标识内置图标集,并提供对该图标集中包含的各个 IIcon 对象的访问。将此接口与 Workbook.getIconSets() 结合使用,可以检索图标集并将其应用于 IIconSetCondition。
IIconSet iconSet = workbook.getIconSets().get(IconSetType.Icon3TrafficLights1);
IconSetType iconSetType = iconSet.getID();
IIcon greenLight = iconSet.get(2);
get(int Index) intgetCount()getID()IconSetType 枚举值。
IIconSet iconSet = workbook.getIconSets().get(IconSetType.Icon3TrafficLights1);
int iconCount = iconSet.getCount();
for (int i = 0; i < iconCount; i++) {
IIcon icon = iconSet.get(i);
}
IconSetType 枚举值。
IIconSetCondition condition = worksheet.getRange("A1:A5").getFormatConditions().addIconSetCondition();
IIconSet iconSet = workbook.getIconSets().get(IconSetType.Icon3TrafficLights1);
condition.setIconSet(iconSet);
IconSetType iconSetType = condition.getIconSet().getID();
IconSetType 值。图标按对应值从低到高排列:索引 0 为最低值图标,getCount() - 1 为最高值图标。索引超出范围无效,使用该图标时可能引发 IndexOutOfBoundsException。
IIconSet iconSet = workbook.getIconSets().get(IconSetType.Icon3TrafficLights1);
IIcon greenLight = iconSet.get(2);
Index - 从零开始的图标索引。