Man illustrationFlower illustration
Excel

Write dataset to excel

Estimated reading: 3 minutes 386 views

Write excel to dataset 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.
Sheet indexIndex of the sheet to work in Excel. If not added, it takes 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.
RowRows that will be written to the Excel.
ColumnColumns 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 Sheet index as shown in the example.

5

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

Share this Doc

Write dataset to excel

Or copy link

CONTENTS
Chat Icon Close Icon