Man illustrationFlower illustration

Docy

Write dataset to excel

Estimated reading: 2 minutes 64 views

Write dataset to excel 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 current location that has already data:

NONE

Copies your data to current place by moving the existing data to the right:

RIGHT

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

DOWN
CONTENTS