Excel.DataValidationOperator enum

包:
excel

表示数据验证运算符枚举。

注解

API 集：ExcelApi 1.8

使用方

示例

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/22-data-validation/data-validation-types.yaml

function applyTextLength(sheet: Excel.Worksheet) {
    // Text must be 10 characters or fewer.
    const basicRule: Excel.BasicDataValidation = {
        formula1: 10,
        operator: Excel.DataValidationOperator.lessThanOrEqualTo
    };
    const rule: Excel.DataValidationRule = { textLength: basicRule };
    sheet.getRange("B7").dataValidation.rule = rule;
}

字段

between = "Between"
equalTo = "EqualTo"
greaterThan = "GreaterThan"
greaterThanOrEqualTo = "GreaterThanOrEqualTo"
lessThan = "LessThan"
lessThanOrEqualTo = "LessThanOrEqualTo"
notBetween = "NotBetween"
notEqualTo = "NotEqualTo"