IIconSortField

Interface IIconSortField

All Superinterfaces:

ISortField

All Known Implementing Classes:

IconSortField

---

public interface IIconSortField extends ISortField

表示基于图标的排序字段。

 worksheet.getRange("A1:A4").setValue(new Object[][] {{3}, {1}, {4}, {2}});
 IRange keyRange = worksheet.getRange("A1:A4");
 keyRange.getFormatConditions().addIconSetCondition().setIconSet(
     workbook.getIconSets().get(IconSetType.Icon3TrafficLights1));
 IIcon icon = workbook.getIconSets().get(IconSetType.Icon3TrafficLights1).get(0);
 IIconSortField sortField = new IconSortField(keyRange, icon, SortOrder.Descending);
 ISort sort = worksheet.getSort();
 sort.getSortFields().add(sortField);
 sort.setRange(keyRange);
 sort.apply();
 

• Method Summary

  All MethodsInstance MethodsAbstract Methods

  Modifier and Type

  Method

  Description

  IIcon

  getIcon()

  获取此图标排序字段使用的 IIcon。

  SortOrder

  getOrder()

  获取排序顺序。

  Methods inherited from interface com.grapecity.documents.excel.ISortField

  getKey, getPriority, getSortOn, setPriority

• Method Details

  • getOrder

    SortOrder getOrder()

    获取排序顺序。

    返回 SortOrder，该值确定匹配图标是按升序还是降序排序。

    
     worksheet.getRange("A1:A4").setValue(new Object[][] {{3}, {1}, {4}, {2}});
     IIcon icon = workbook.getIconSets().get(IconSetType.Icon3TrafficLights1).get(0);
     IIconSortField sortField = new IconSortField(worksheet.getRange("A1:A4"), icon, SortOrder.Descending);
     SortOrder order = sortField.getOrder();
     

    Returns:

    此图标排序字段的排序顺序。

  • getIcon

    IIcon getIcon()

    获取此图标排序字段使用的 IIcon。

    
     IIcon icon = workbook.getIconSets().get(IconSetType.Icon3Arrows).get(0);
     IIconSortField sortField = new IconSortField(worksheet.getRange("A2:A4"), icon);
     IIcon sortIcon = sortField.getIcon();
     

    Returns:

    用于排序的 IIcon。