Man illustrationFlower illustration

Docy

Write dataset to excel

Estimated reading: 2 minutes 80 views

Write excel to dataset activity allows the changes to be written to the relevant Excel file after the dataset processes are completed.


*Excel nameReference name of Excel which will be opened
*Dataset nameReference name of dataset.
Sheet nameName of the sheet to work in Excel. If not added, it takes the first sheet by default.
DestinationSets destination cell on which the operation will write the result.
*ShiftIt is the field where the data set will be written to Excel.
Include headerIf there are column header in the resulting dataset, True is selected.
Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

${newExcel}

You can use the Dataset name as shown in the example.

${newDataset}

You can use the Sheet name as shown in the example.

Sheet1

You can use the Destination as shown in the example.

A1

You can use the Shift as shown in the example.

Copies the data to the current location that is already data:

NONE

Copies your data to a valid location by shifting the current data to the right:

RIGHT

Copies your data to the current location by moving the existing data down:

DOWN

Sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.
If the Destination field is not filled, the dataset prints its range directly into Excel. If destination is given and if there is data in excel in the field where it is given, that data moves next to the dataset range.

CONTENTS