set_number_format
Apply built-in or custom number formats to a specified cell range in an Excel file, converting values to currency, percent, integer, date, or other displays.
Instructions
设置数字格式。
number_format 可传内置名或自定义格式码:
cny → ¥#,##0(人民币整数)
cny2 → ¥#,##0.00
cny_dash → ¥#,##0;(¥#,##0);-(零显示为短横)
percent → 0.0%(注意:值必须存小数,存 0.15 显示 15.0%)
multiple → 0.0x(估值倍数)
int → #,##0;date → yyyy-mm-dd
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"file_path": "<file_path>",
"cell_range": "<cell_range>",
"number_format": "<number_format>"
},
"name": "set_number_format"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | ||
| file_path | Yes | ||
| cell_range | Yes | ||
| number_format | Yes |