excelGet
Version 22.0.8473
excelGet
Version 22.0.8473
Queries the specified Excel worksheet.
必要なパラメータ
- sheet:The name of the Excel worksheet.
オプションのパラメータ
- version:The version of Excel you are using. The allowed values are ‘AUTO, 95, 97-2003, 2007’.デフォルト値は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.