List worksheets
xlide_list_sheetsInspect an Excel file's worksheets, used ranges, hidden status, and named ranges before reading cells to request a range that contains data.
Instructions
Lists the worksheets in an Excel file with their used ranges, whether each is hidden, and the workbook's named ranges. Call this before reading cells, so the range you ask for is one that holds data. Works on .xlsx, .xlsm and .xlam; a .xlsb or .xls keeps its grid in a binary format this server does not read.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| timeout | No | Seconds allowed if Excel has to answer. | |
| file_path | Yes | Absolute path to the Excel file. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||