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
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | ||
| file_path | Yes | ||
| cell_range | Yes | ||
| number_format | Yes |