Write dataset to excel

Estimated reading: 2 minutes 305 views

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

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*Dataset name	The reference name of the dataset which has already been created is chosen in the dropdown.
Sheet name	The name of the sheet to work in excel can be added. If not added, it is accepted as the first sheet by default.
Destination	It can be determined from which cell the dataset will be written in excel. If the Destination field is not filled, the dataset will be written its range directly into Excel. Note: If the target range/area (Destination) is given and there is already data in the given area, that data will be written to the side of the dataset range.
*Shift	Specifies how to write the dataset to the excel file.
Include header	If 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.

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