批量设置单元格样式
PUT
/sheets/v2/spreadsheets/{spreadsheetToken}/styles_batch_update
请求参数
Path 参数
Body 参数application/json
返回响应
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request PUT '/sheets/v2/spreadsheets//styles_batch_update' \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data-raw '{
"data": [
{
"ranges": [
"string",
"string"
],
"style": {
"font": {
"bold": true,
"italic": true,
"fontSize": "10pt/1.5",
"clean": false
},
"textDecoration": 0,
"formatter": "",
"hAlign": 0,
"vAlign": 0,
"foreColor": "#000000",
"backColor": "#21d11f",
"borderType": "FULL_BORDER",
"borderColor": "#ff0000",
"clean": false
}
},
{
"ranges": [
"string"
],
"style": {}
}
]
}'响应示例响应示例
{
"code": 0,
"msg": "Success",
"data": {
"spreadsheetToken": "string",
"totalUpdatedCells": 0,
"totalUpdatedColumns": 0,
"totalUpdatedRows": 0,
"revision": 0,
"responses": [
{
"spreadsheetToken": "string",
"updatedRange": "string",
"updatedRows": 0,
"updatedColumns": 0,
"updatedCells": 0
}
]
}
}
扫码加入交流群修改于 2025-10-21 06:08:35