Man illustrationFlower illustration
MS Excel

Read excel to dataset

Estimated reading: 1 minute 315 views

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


*Excel nameThe reference name of the excel file which has already been opened or created is chosen in the dropdown.
*New dataset nameThe reference name is given to the dataset which will create in this field.
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.
RangeExcel sheet range from which to received data is written.
Has headerIf the dataset has column headings, true is selected.
Include Formatted TextIf it is desired to include formatted text in a new column, 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 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 Range as shown in the example.

A1:C5
Share this Doc

Read excel to dataset

Or copy link

CONTENTS
Chat Icon Close Icon