TOOL API

sheet.operation_sheet

Runs a JavaScript script against a Tencent Docs online spreadsheet to read and write cell values, set formulas, colors, row heights and column widths, insert or delete rows and columns, and query sheet info. 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.operation_sheet
Provider: Tencent Docs
Average response: 0 ms
Calls in 7 days: 0

Input parameters

file_idrequired

在线表格的唯一标识符

js_scriptrequired

在沙箱中执行的JS脚本。行列索引从0开始。通过Spreadsheet对象访问表格数据，进行各种操作

sheet_id

要操作的子表ID