Read Excel
 Previous Top Next
The Read Excel component allows you to read data from a Microsoft Excel Spreadsheet. Data can be read from the file in one of two ways:

·    Reading all data a starting column and row index into an in-memory dataset.
·    Reading specific cells and populating task variables.


graphic
  
File Name
Specify the path to the input Excel File.
Worksheet
Specify the name of the worksheet to read data from, if you leave it blank it will use the default active worksheet.

To read specific cells
Column
Enter the column index for the value to read.
Row
Enter the row index for the value to read.
Variable
Enter the name of the Task Variable that will be created and populated with the value.

To read a range of data into an in-memory dataset
Dataset
Specify the name of the dataset to populate.
Start Column and Start Row
The starting column and row index to read from.
End Column and End Row
The ending column and row index to read to.