排序区域
sort_rangeSorts a specified range in an Excel sheet by a column, modifying the file while leaving other content untouched. Optionally use header names for reliable sorting.
Instructions
对一个区域按某列排序(会修改文件)。区域外的内容不动。有表头时传 hasHeader: true 并用表头名指定列更稳妥。
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| order | Yes | ||
| range | Yes | 矩形区域,如 `A1:D20` | |
| filePath | Yes | Excel 文件的绝对路径,例如 `C:\Users\xx\报表.xlsx` 或 `/Users/xx/报表.xlsx`。支持 .xlsx / .xls / .csv | |
| hasHeader | No | ||
| keyColumn | Yes | ||
| sheetName | Yes |