ExcelToDatatable
When to use the ExcelToDatatable activity
This activity helps you convert a worksheet data to a new DataTable.
Figure 1
Activity Name
|
Picture
|
ExcelToDatatable
|
![a](/robility/sites/default/files/inline-images/ea_4.png)
|
Technical Reference
![1](/robilitydocs.sutherlandglobal.com/Robility/sites/default/files/inline-images/Excel%20to%20Data%20table%20SS_0.JPG)
IncludeColumnHeaders should be checked if you require the header column for processing.
Datatable: the variable type should be defined as System.Data.Datatable.
Activity: The ExcelToDatatable activity helps read data from an excel worksheet and store it to a data table variable for further processing for automation.
Figure 2
![1.5](/robility/sites/default/files/inline-images/1.5_23.png)