# 更新区域数据




**标签**：`【电子表格】` 


## 请求说明
| 字段          | 值                  |
|--------------|---------------------|
| **<div style="white-space: nowrap;">请求地址</div>**  | https://openapi.wps.cn/v7/sheets/{file_id}/worksheets/{worksheet_id}/range_data/batch_update          |
| **<div style="white-space: nowrap;">HTTP 方法</div>** | `POST`    |
| **<div style="white-space: nowrap;">接口描述</div>**  | 无 |
| **<div style="white-space: nowrap;">签名方式</div>**  | [KSO-1](https://open.wps.cn/documents/app-integration-dev/wps365/server/api-description/signature-description) |
| **<div style="white-space: nowrap;">限频策略</div>** | 无 |
| **<div style="white-space: nowrap;">权限要求</div>** | <div><div>管理传统表格(应用授权) `kso.sheets.readwrite`</div><div style="margin-top: 5px;"></div><div>管理传统表格(用户授权) `kso.sheets.readwrite`</div></div> |




## 路径参数 (Path)
| 属性名 | 类型 | 是否必填 | 描述 | 可选值 |
|-------|------|------|-------|-------|
| <div style="white-space: nowrap;">file_id</div> | `string` | 是 | 文件ID | - 
| <div style="white-space: nowrap;">worksheet_id</div> | `integer` | 是 | 工作表ID | - 





## 请求体(Body)
**请求体格式:** `application/json`
<OpenapiRenderTable  dataSource='[{"key":"range_data","name":"range_data","deprecated":false,"type":"array[object]","required":"是","enum":[],"xEnum":[],"description":"<p>单元格操作数组</p>\n","children":[{"key":"range_data.items.cell_pic_info","name":"cell_pic_info","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>图片信息（op_type = picture）</p>\n","children":[{"key":"range_data.items.cell_pic_info.height","name":"height","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>图片高度</p>\n","children":[]},{"key":"range_data.items.cell_pic_info.pic_content","name":"pic_content","deprecated":false,"type":"string","required":"是","enum":[],"xEnum":[],"description":"<p>不同类型中的具体内容</p>\n","children":[]},{"key":"range_data.items.cell_pic_info.tag","name":"tag","deprecated":false,"type":"string","required":"是","enum":["sheet_pic_type_local","sheet_pic_type_attachment","sheet_pic_type_url"],"xEnum":["sheet_pic_type_local","sheet_pic_type_attachment","sheet_pic_type_url"],"description":"<p>local/attachment/url 3选1</p>\n","children":[]},{"key":"range_data.items.cell_pic_info.width","name":"width","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>图片宽度</p>\n","children":[]}]},{"key":"range_data.items.col_from","name":"col_from","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>起始列</p>\n","children":[]},{"key":"range_data.items.col_to","name":"col_to","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>终止列</p>\n","children":[]},{"key":"range_data.items.formula","name":"formula","deprecated":false,"type":"string","required":"否","enum":[],"xEnum":[],"description":"<p>公式或内容（op_type = formula）</p>\n","children":[]},{"key":"range_data.items.merge_type","name":"merge_type","deprecated":false,"type":"string","required":"否","enum":["merge_type_center","merge_type_content","merge_type_same","merge_type_columns"],"xEnum":["merge_type_center","merge_type_content","merge_type_same","merge_type_columns"],"description":"<p>合并类型（op_type = merge）</p>\n","children":[]},{"key":"range_data.items.op_type","name":"op_type","deprecated":false,"type":"string","required":"是","enum":["cell_operation_type_formula","cell_operation_type_picture","cell_operation_type_format","cell_operation_type_merge"],"xEnum":["cell_operation_type_formula","cell_operation_type_picture","cell_operation_type_format","cell_operation_type_merge"],"description":"<p>单元格操作类型</p>\n","children":[]},{"key":"range_data.items.row_from","name":"row_from","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>起始行</p>\n","children":[]},{"key":"range_data.items.row_to","name":"row_to","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>终止行</p>\n","children":[]},{"key":"range_data.items.xf","name":"xf","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>格式信息（op_type = format）</p>\n","children":[{"key":"range_data.items.xf.alc_h","name":"alc_h","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>水平对齐</p>\n","children":[]},{"key":"range_data.items.xf.alc_v","name":"alc_v","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>垂直对齐</p>\n","children":[]},{"key":"range_data.items.xf.clr_bottom","name":"clr_bottom","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>下边框颜色</p>\n","children":[{"key":"range_data.items.xf.clr_bottom.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.clr_bottom.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.clr_bottom.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.clr_diag_down","name":"clr_diag_down","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>向下斜线边框颜色</p>\n","children":[{"key":"range_data.items.xf.clr_diag_down.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.clr_diag_down.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.clr_diag_down.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.clr_diag_up","name":"clr_diag_up","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>向上斜线边框颜色</p>\n","children":[{"key":"range_data.items.xf.clr_diag_up.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.clr_diag_up.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.clr_diag_up.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.clr_inside_horz","name":"clr_inside_horz","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>内框横线颜色</p>\n","children":[{"key":"range_data.items.xf.clr_inside_horz.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.clr_inside_horz.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.clr_inside_horz.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.clr_inside_vert","name":"clr_inside_vert","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>内框竖线颜色</p>\n","children":[{"key":"range_data.items.xf.clr_inside_vert.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.clr_inside_vert.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.clr_inside_vert.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.clr_left","name":"clr_left","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>左边框颜色</p>\n","children":[{"key":"range_data.items.xf.clr_left.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.clr_left.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.clr_left.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.clr_right","name":"clr_right","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>右边框颜色</p>\n","children":[{"key":"range_data.items.xf.clr_right.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.clr_right.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.clr_right.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.clr_top","name":"clr_top","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>上边框颜色</p>\n","children":[{"key":"range_data.items.xf.clr_top.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.clr_top.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.clr_top.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.dg_bottom","name":"dg_bottom","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>下边框线型</p>\n","children":[]},{"key":"range_data.items.xf.dg_diag_down","name":"dg_diag_down","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>向下斜线边框线型</p>\n","children":[]},{"key":"range_data.items.xf.dg_diag_up","name":"dg_diag_up","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>向上斜线边框线型</p>\n","children":[]},{"key":"range_data.items.xf.dg_inside_horz","name":"dg_inside_horz","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>内框线型</p>\n","children":[]},{"key":"range_data.items.xf.dg_inside_vert","name":"dg_inside_vert","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>内框线型</p>\n","children":[]},{"key":"range_data.items.xf.dg_left","name":"dg_left","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>左边框线型</p>\n","children":[]},{"key":"range_data.items.xf.dg_right","name":"dg_right","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>右边框线型</p>\n","children":[]},{"key":"range_data.items.xf.dg_top","name":"dg_top","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>上边框线型</p>\n","children":[]},{"key":"range_data.items.xf.fill","name":"fill","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>填充</p>\n","children":[{"key":"range_data.items.xf.fill.back","name":"back","deprecated":false,"type":"object","required":"是","enum":[],"xEnum":[],"description":"<p>背景色</p>\n","children":[{"key":"range_data.items.xf.fill.back.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.fill.back.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.fill.back.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.fill.fore","name":"fore","deprecated":false,"type":"object","required":"是","enum":[],"xEnum":[],"description":"<p>前景色</p>\n","children":[{"key":"range_data.items.xf.fill.fore.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.fill.fore.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.fill.fore.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.fill.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>填充类型</p>\n","children":[]}]},{"key":"range_data.items.xf.font","name":"font","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>字体</p>\n","children":[{"key":"range_data.items.xf.font.bls","name":"bls","deprecated":false,"type":"boolean","required":"否","enum":[],"xEnum":[],"description":"<p>粗体</p>\n","children":[]},{"key":"range_data.items.xf.font.char_set","name":"char_set","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>字符集</p>\n","children":[]},{"key":"range_data.items.xf.font.color","name":"color","deprecated":false,"type":"object","required":"否","enum":[],"xEnum":[],"description":"<p>颜色</p>\n","children":[{"key":"range_data.items.xf.font.color.tint","name":"tint","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>透明度，调节颜色深浅</p>\n","children":[]},{"key":"range_data.items.xf.font.color.type","name":"type","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>颜色类型</p>\n","children":[]},{"key":"range_data.items.xf.font.color.value","name":"value","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"<p>ARGB 的整数值</p>\n","children":[]}]},{"key":"range_data.items.xf.font.dy_height","name":"dy_height","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>字体高度（单位 Twip）</p>\n","children":[]},{"key":"range_data.items.xf.font.italic","name":"italic","deprecated":false,"type":"boolean","required":"否","enum":[],"xEnum":[],"description":"<p>斜体</p>\n","children":[]},{"key":"range_data.items.xf.font.name","name":"name","deprecated":false,"type":"string","required":"否","enum":[],"xEnum":[],"description":"<p>字体名称</p>\n","children":[]},{"key":"range_data.items.xf.font.sss","name":"sss","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>上下标类型</p>\n","children":[]},{"key":"range_data.items.xf.font.strikeout","name":"strikeout","deprecated":false,"type":"boolean","required":"否","enum":[],"xEnum":[],"description":"<p>删除线</p>\n","children":[]},{"key":"range_data.items.xf.font.theme_font","name":"theme_font","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>字体类型</p>\n","children":[]},{"key":"range_data.items.xf.font.uls","name":"uls","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>下划线类型</p>\n","children":[]}]},{"key":"range_data.items.xf.hidden","name":"hidden","deprecated":false,"type":"boolean","required":"否","enum":[],"xEnum":[],"description":"<p>隐藏公式</p>\n","children":[]},{"key":"range_data.items.xf.indent","name":"indent","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>缩进</p>\n","children":[]},{"key":"range_data.items.xf.locked","name":"locked","deprecated":false,"type":"boolean","required":"否","enum":[],"xEnum":[],"description":"<p>锁定单元格</p>\n","children":[]},{"key":"range_data.items.xf.mask_cats","name":"mask_cats","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>掩码</p>\n","children":[]},{"key":"range_data.items.xf.mask_cats_font","name":"mask_cats_font","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>掩码字体</p>\n","children":[]},{"key":"range_data.items.xf.numfmt","name":"numfmt","deprecated":false,"type":"string","required":"否","enum":[],"xEnum":[],"description":"<p>数字格式</p>\n","children":[]},{"key":"range_data.items.xf.reading_order","name":"reading_order","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>文字方向</p>\n","children":[]},{"key":"range_data.items.xf.shrink_to_fit","name":"shrink_to_fit","deprecated":false,"type":"boolean","required":"否","enum":[],"xEnum":[],"description":"<p>缩小字体填充</p>\n","children":[]},{"key":"range_data.items.xf.trot","name":"trot","deprecated":false,"type":"integer","required":"否","enum":[],"xEnum":[],"description":"<p>文字旋转</p>\n","children":[]},{"key":"range_data.items.xf.wrap","name":"wrap","deprecated":false,"type":"boolean","required":"否","enum":[],"xEnum":[],"description":"<p>自动换行</p>\n","children":[]}]}]}]' />

## 请求体示例
```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`<br/>
**响应体格式:** `application/json`
<OpenapiRenderTable hideHeaderKeys='required' dataSource='[{"key":"code","name":"code","deprecated":false,"type":"integer","required":"是","enum":[],"xEnum":[],"description":"-","children":[]},{"key":"msg","name":"msg","deprecated":false,"type":"string","required":"是","enum":[],"xEnum":[],"description":"<p>人可阅读的文本信息，可能会按不同的语言或地区返回不同的文本信息。</p>\n","children":[]}]' />

## 响应体示例
```json
{
  "code": 0,
  "msg": "string"
}
```