Man illustrationFlower illustration

Docy

Read excel to dataset

Estimated reading: 1 minute 64 views

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


*Excel nameReference name of Excel which will be opened.
*New dataset nameReference name of dataset which will be created.
Sheet nameName of the sheet to work in Excel. If not added, it takes the first sheet by default.
RangeExcel sheets range from which to fetch data. If not added, it takes the all data by default.
Has headerIf the dataset has column headings, true is selected.
Include Formatted TextInclude formatted text in a new column.
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
CONTENTS