Write dataset to excel

Estimated reading: 3 minutes 337 views

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.}

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 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

You can use the Row as shown in the example.

1:5

You can use the Column as shown in the example.

1:5

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.

Write dataset to excel

Write dataset to excel

CONTENTS