excel_read_sheet
Retrieve data from specified Excel sheet ranges efficiently. Supports pagination, customizable cell ranges, and formula display for precise data extraction.
Instructions
Read values from Excel sheet with pagination.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
fileAbsolutePath | Yes | Absolute path to the Excel file | |
knownPagingRanges | No | List of already read paging ranges | |
range | No | Range of cells to read in the Excel sheet (e.g., "A1:C10"). [default: first paging range] | |
sheetName | Yes | Sheet name in the Excel file | |
showFormula | Yes | Show formula instead of value |