Read excel to dataset

Estimated reading: 2 minutes 264 views

Read excel to dataset activity is used for converting the desired Excel file will be processed into dataset.

*Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
*New dataset name	The reference name is given to the dataset which will create in this field.
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.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Range	Excel sheet range from which to received data is written.
Has header	If the dataset has column headings, true is selected.
Include Formatted Text	If it is desired to include formatted text in a new column, true is selected.
Set to null	This checkbox provides the set cell values that are empty string to null.

_{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 New 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.

You can use the Range as shown in the example.

A1:C5

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 Range field is not filled, all of the data in the excel file constitutes the dataset range.
If no Destination is given, it is copied to cell A1.

Read excel to dataset

Read excel to dataset

CONTENTS