Write dataset to excel

Write excel to dataset 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.
Row Rows that will be written to the Excel.
Column Columns that will be written to the Excel.

Note: * Fields selected with are required, others are optional.

Excel name example

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

${newExcel}

Dataset name example

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

${newDataset}

Sheet name example

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

Sheet1

Destination example

You can use the Destination as shown in the example .

A1

Shift examples

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

Row example

You can use the Row as shown in the example.

1:5

Column example

You can use the Column as shown in the example.

1:5

Note

The 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 the 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.