Man illustrationFlower illustration

Write dataset to excel

Estimated reading: 2 minutes 223 views

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


*Excel nameThe reference name of the excel file which has already been opened or created is chosen in the dropdown.
*Dataset nameThe reference name of the dataset which has already been created is chosen in the dropdown.
Sheet nameThe name of the sheet to work in excel can be added. If not added, it is accepted as the first sheet by default.
DestinationIt 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.
*ShiftSpecifies how to write the dataset to the excel file.
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
Share this Doc

Write dataset to excel

Or copy link

CONTENTS
Chat Icon Close Icon