ddCreateDataSetFromExcelFile (Accessing Contents of and Persisting Files within the "Files" module)
Compatible with:
- Purpose
- This command can be used to create a new dataset in memory with a name specified in the 'Value' field
- By default, the attributes for the Data Definition are taken from the zeroth row. On specifying the row number optionally, the respective row values are considered as the attributes for the Data Definition
- Syntax
- ddCreateDataSetFromExcelFile(variableHoldingWorksheetRangeHandle(RowNumber) || variableHoldingRangeOffset (or)
- variableHoldingWorksheetHandle(RowNumber) (or)
- variableHoldingWorkbookHandle (RowNumber), dataset)
- Target
- variableHoldingWorksheetRangeHandle(RowNumber) || variableHoldingRangeOffset (or)
- variableHoldingWorksheetHandle(RowNumber) (or)
- variableHoldingWorkbookHandle(RowNumber)
- Value
- dataset
- Return Value
- N/A
- Errors & Exceptions
Condition Error/Exception Message Invalid Range Offset The RangeOffset provided as input is invalid for the given range. Variable not mapped The variable passed as input does not hold any workbook/worksheet/worksheet range. Invalid Row Number Invalid Row Number provided to create Data Definition.