修改条件格式

标签：【电子表格】

请求说明

字段	值
请求地址	配置域名+/openapi+/v7/sheets/{file_id}/worksheets/{worksheet_id}/cf_rules/update
HTTP 方法	POST
接口描述	无
签名方式	KSO-1（配置域名+/openapi不参与签名）
限频策略	无
权限要求	查询和管理传统表格(应用授权) kso.sheets.readwrite 查询和管理传统表格(用户授权) kso.sheets.readwrite

请求头 (Headers)

属性名	类型	是否必填	描述	可选值
X-Kso-Date	string	是	RFC1123 格式的日期，例: Wed, 23 Jan 2013 06:43:08 GMT	-
X-Kso-Authorization	string	是	KSO-1 签名值，详见《签名方法》	-
Authorization	string	是	授权凭证，格式为：Bearer {access_token}	-

路径参数 (Path)

属性名	类型	是否必填	描述	可选值
file_id	string	是	文件ID	-
worksheet_id	integer	是	工作表ID	-

请求体(Body)

请求体格式: application/json

没有可用的数据

请求体示例

{
  "rule": {
    "cf_rule_type": "cf_rule_type_value_range",
    "formula1": "string",
    "formula2": "string",
    "id": 0,
    "lastone": true,
    "operator": "cf_rule_operator_greater",
    "priority": 0,
    "ranges": [
      {
        "col_from": 0,
        "col_to": 0,
        "row_from": 0,
        "row_to": 0
      }
    ],
    "rank": "string",
    "xf": {
      "alc_h": 0,
      "alc_v": 0,
      "clr_bottom": {
        "tint": 0,
        "type": 0,
        "value": 0
      },
      "clr_diag_down": {
        "tint": 0,
        "type": 0,
        "value": 0
      },
      "clr_diag_up": {
        "tint": 0,
        "type": 0,
        "value": 0
      },
      "clr_inside_horz": {
        "tint": 0,
        "type": 0,
        "value": 0
      },
      "clr_inside_vert": {
        "tint": 0,
        "type": 0,
        "value": 0
      },
      "clr_left": {
        "tint": 0,
        "type": 0,
        "value": 0
      },
      "clr_right": {
        "tint": 0,
        "type": 0,
        "value": 0
      },
      "clr_top": {
        "tint": 0,
        "type": 0,
        "value": 0
      },
      "dg_bottom": 0,
      "dg_diag_down": 0,
      "dg_diag_up": 0,
      "dg_inside_horz": 0,
      "dg_inside_vert": 0,
      "dg_left": 0,
      "dg_right": 0,
      "dg_top": 0,
      "fill": {
        "back": {
          "tint": 0,
          "type": 0,
          "value": 0
        },
        "fore": {
          "tint": 0,
          "type": 0,
          "value": 0
        },
        "type": 0
      },
      "font": {
        "bls": true,
        "char_set": 0,
        "color": {
          "tint": 0,
          "type": 0,
          "value": 0
        },
        "dy_height": 0,
        "italic": true,
        "name": "string",
        "sss": 0,
        "strikeout": true,
        "theme_font": 0,
        "uls": 0
      },
      "hidden": true,
      "indent": 0,
      "locked": true,
      "mask_cats": 0,
      "mask_cats_font": 0,
      "numfmt": "string",
      "reading_order": 0,
      "shrink_to_fit": true,
      "trot": 0,
      "wrap": true
    }
  }
}

响应体(Response)

HTTP状态码: 200
响应体格式: application/json

没有可用的数据

响应体示例

{
  "code": 0,
  "msg": "string"
}