设置单元格样式

PUT {{base_url}}/sheets/v2/spreadsheets/:spreadsheetToken/style

该接口用于根据 spreadsheetToken 、range 和样式信息更新单元格样式；单次写入不超过5000行，100列。

参考接口文档：设置单元格样式

Request Body

{"appendStyle"=>{"range"=>"1QXD0s!A3:C4", "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}}}

RESPONSES

status: OK

{"code":0,"data":{"updates":{"revision":13,"spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg","updatedCells":6,"updatedColumns":3,"updatedRange":"1QXD0s!A3:C4","updatedRows":2}},"msg":"success"}