excelGet
Version 22.0.8473
excelGet
Version 22.0.8473
Queries the specified Excel worksheet.
Required Parameters
- sheet: The name of the Excel worksheet.
Optional Parameters
- version: The version of Excel you are using. The allowed values are ‘AUTO, 95, 97-2003, 2007’. The default value is ‘AUTO’.
- file: The path to the Excel workbook.
- handle: The handle for the Excel file.
- map:*: This set of inputs contains a mapping of the attribute name and the name of the cell whose value is to be retrieved from the spreadsheet. For example, the attribute name map:MyValue which has a value of C1 will push an attribute named MyValue with the value found in the cell at C1 in the sheet. A range of cell names can also be specified to retrieve a range of cell values.
Output Attributes
- *: Dependent on the content of the sheet and the query specified. If column headers are present they will be used to name the output attributes.