更新区域数据

标签：【智能表格】

请求说明

字段	值
请求地址	配置域名+/openapi+/v7/airsheet/{file_id}/worksheets/{worksheet_id}/range_data/batch_update
HTTP 方法	POST
接口描述	无
签名方式	KSO-1（配置域名+/openapi不参与签名）
限频策略	无
权限要求	查询和管理智能表格(应用授权) kso.airsheet.readwrite 查询和管理智能表格(用户授权) kso.airsheet.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

没有可用的数据

请求体示例

{
  "range_data": [
    {
      "cell_pic_info": {
        "height": 0,
        "pic_content": "string",
        "tag": "sheet_pic_type_local",
        "width": 0
      },
      "col_from": 0,
      "col_to": 0,
      "formula": "string",
      "merge_type": "merge_type_center",
      "op_type": "cell_operation_type_formula",
      "row_from": 0,
      "row_to": 0,
      "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"
}