Excel.Icon interface

Remarques

Jeu d’API : ExcelApi 1.2

Utilisateur

• Excel.ConditionalIconCriterion : customIcon
• Excel.Filter : applyIconFilter
• Excel.FilterCriteria : icon
• Excel.FiveArrowsGraySet : grayDownArrow, grayDownInclineArrow, graySideArrow, grayUpArrow, grayUpInclineArrow
• Excel.FiveArrowsSet : greenUpArrow, redDownArrow, yellowDownInclineArrow, yellowSideArrow, yellowUpInclineArrow
• Excel.FiveBoxesSet : fourFilledBoxes, noFilledBoxes, oneFilledBox, threeFilledBoxes, twoFilledBoxes
• Excel.FiveQuartersSet : blackCircle, circleWithOneWhiteQuarter, circleWithThreeWhiteQuarters, circleWithTwoWhiteQuarters, whiteCircleAllWhiteQuarters
• Excel.FiveRatingSet : fourBars, noBars, oneBar, threeBars, twoBars
• Excel.FourArrowsGraySet : grayDownArrow, grayDownInclineArrow, grayUpArrow, grayUpInclineArrow
• Excel.FourArrowsSet : greenUpArrow, redDownArrow, yellowDownInclineArrow, yellowUpInclineArrow
• Excel.FourRatingSet : fourBars, oneBar, threeBars, twoBars
• Excel.FourRedToBlackSet : blackCircle, grayCircle, pinkCircle, redCircle
• Excel.FourTrafficLightsSet : blackCircleWithBorder, greenCircle, redCircleWithBorder, yellowCircle
• Excel.SortField : icon
• Excel.ThreeArrowsGraySet : grayDownArrow, graySideArrow, grayUpArrow
• Excel.ThreeArrowsSet : greenUpArrow, redDownArrow, yellowSideArrow
• Excel.ThreeFlagsSet : greenFlag, redFlag, yellowFlag
• Excel.ThreeSignsSet : vertCercle, rougeDiamant, jauneTriangle
• Excel.ThreeStarsSet : goldStar, halfGoldStar, silverStar
• Excel.ThreeSymbols2Set : greenCheck, redCross, yellowExclamation
• Excel.ThreeSymbolsSet : greenCheckSymbol, redCrossSymbol, yellowExclamationSymbol
• Excel.ThreeTrafficLights1Set : greenCircle, redCircleWithBorder, yellowCircle
• Excel.ThreeTrafficLights2Set : greenTrafficLight, redTrafficLight, yellowTrafficLight
• Excel.ThreeTrianglesSet : greenUpTriangle, redDownTriangle, yellowDash

Exemples

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/14-conditional-formatting/conditional-formatting-basic.yaml

await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getItem("Sample");
    const range = sheet.getRange("B8:E13");
    const conditionalFormat = range.conditionalFormats
        .add(Excel.ConditionalFormatType.iconSet);
    const iconSetCF = conditionalFormat.iconSet;
    iconSetCF.style = Excel.IconSet.threeTriangles;

    /*
        The iconSetCF.criteria array is automatically prepopulated with
        criterion elements whose properties have been given default settings.
        You can't write to each property of a criterion directly. Instead,
        replace the whole criteria object.

        With a "three*" icon set style, such as "threeTriangles", the third
        element in the criteria array (criteria[2]) defines the "top" icon;
        e.g., a green triangle. The second (criteria[1]) defines the "middle"
        icon. The first (criteria[0]) defines the "low" icon, but it
        can often be left empty as the following object shows, because every
        cell that does not match the other two criteria always gets the low
        icon.            
    */
    
    const lowIcon: Excel.Icon = {
        set: Excel.IconSet.threeFlags,
        index: 0
    };

    iconSetCF.criteria = [
        {
            customIcon: lowIcon
        } as Excel.ConditionalIconCriterion,
        {
            type: Excel.ConditionalFormatIconRuleType.number,
            operator: Excel.ConditionalIconCriterionOperator.greaterThanOrEqual,
            formula: "=700"
        },
        {
            type: Excel.ConditionalFormatIconRuleType.number,
            operator: Excel.ConditionalIconCriterionOperator.greaterThanOrEqual,
            formula: "=1000",
        }
    ];
    await context.sync();
});

Propriétés

index

index: number;

set

set: Excel.IconSet | "Invalid" | "ThreeArrows" | "ThreeArrowsGray" | "ThreeFlags" | "ThreeTrafficLights1" | "ThreeTrafficLights2" | "ThreeSigns" | "ThreeSymbols" | "ThreeSymbols2" | "FourArrows" | "FourArrowsGray" | "FourRedToBlack" | "FourRating" | "FourTrafficLights" | "FiveArrows" | "FiveArrowsGray" | "FiveRating" | "FiveQuarters" | "ThreeStars" | "ThreeTriangles" | "FiveBoxes";