TOOL API
sheet.
Sets the value of a specific cell in a Tencent Docs online spreadsheet, supporting text, number, boolean, and formula values. If both tencent-docs (personal) and tencent-docs-oa (enterprise) are connected, use AskUserQuestion to let the user pick the target account before invoking this tool.
productivityOAuth1 credits
Call information
- Tool slug
- tencent-docs.sheet.set_cell_value
- Provider
- Tencent Docs
- Average response
- 0 ms
- Calls in 7 days
- 0
Input parameters
bool_value布尔值，value_type 为 BOOL 时使用
col列索引（0-based）
file_idrequired在线表格的唯一标识符
formula公式，value_type 为 FORMULA 时使用，例如 "=SUM(A1:A10)"
number_value数值，value_type 为 NUMBER 时使用
row行索引（0-based）
sheet_idrequired子表 ID(必填)
string_value字符串值，value_type 为 STRING 时使用
value_type值类型，合法值: NUMBER, STRING, BOOL, FORMULA（不区分大小写）