ddPersistDataSetToExcelFile (Accessing Contents of and Persisting Files within the "Files" module)
Compatible with:
- Purpose
- This command is used to persist a Dataset in memory into an Excel file
- On selecting the 'Override' option, the content gets overridden from the dataset to the excel file. This is an optional parameter on specifying 'variableHoldingWorksheetRangeHandle' as value in the 'Target' field
- On selecting the 'Append' option, the content gets appended at the end of the excel file
- The specified range/offset range should exist within the given range of cells in the excel file
- Syntax
- ddPersistDataSetToExcelFile(variableHoldingWorksheetRangeHandle||override (or)
- variableHoldingWorksheetHandle||override|append (or)
- variableHoldingWorkbookHandle||override|append,
- dataset)
- Target
- variableHoldingWorksheetRangeHandle||override (or)
- variableHoldingWorksheetHandle||override|append (or)
- variableHoldingWorkbookHandle||override|append
- Value
- dataset
- Return Value
- N/A
- Errors & Exceptions
-
Condition Error/Exception Message Non-existing Dataset The dataset passed as input does not exist in the scope of the run. Variable not mapped The variable passed as input does not hold any workbook/worksheet/worksheet range. Invalid Indicator Invalid Indicator. Specified Cell Range The number of cells in the dataset is more than the specified range.