readDataBySheetName
Extract data from a specified sheet in an Excel file by providing the file path, sheet name, and optional row configurations. Ideal for structured data retrieval and analysis.
Instructions
Get data from a specific sheet in the Excel file
Input Schema
Name | Required | Description | Default |
---|---|---|---|
dataStartRow | No | The row number to start reading data from (default: 2) | |
fileAbsolutePath | Yes | The absolute path of the Excel file | |
headerRow | No | tThe row number to use as field names (default: 1) | |
sheetName | Yes | tThe name of the sheet to read |