读取区域内容
read_rangeRead a worksheet's content as a 2D array. Use an optional range (e.g., A1:D20) to load only part of large sheets; empty cells become null and dates become ISO strings.
Instructions
读取一张工作表的内容,返回二维数组。不传 range 则读整张表;表很大时建议先传 range 读一部分(如前 50 行)了解结构。空单元格为 null,日期为 ISO 字符串。
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | No | 矩形区域,如 `A1:D20` | |
| filePath | Yes | Excel 文件的绝对路径,例如 `C:\Users\xx\报表.xlsx` 或 `/Users/xx/报表.xlsx`。支持 .xlsx / .xls / .csv | |
| sheetName | No |