Man illustrationFlower illustration

Docy

Read dataset to excel

Estimated reading: 2 minutes 85 views

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


*Excel nameReference name of Excel that will be opened.
*New dataset nameReference name of dataset that will be created.
Sheet nameName of the sheet to work in Excel. If not added, it takes the first sheet by default.
RangeExcel sheet range from which to fetch data.
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

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.

CONTENTS