How to build data table from excel as it is automatic in uipath?

Help Studio
, ,
1

How to build data table from excel file as it is automatic without doing anything manually in UiPath ?

2

@Bh_P : I think you can use Read range Workbook Activity for the same.

3

Hi @Bh_P ,

Simply use the Read Range Activity provide the sheet name and Range from where you want to read the data.

image

Store it in a Datatable variable.

Or Else, do you just want to get the structure of Datatable with no rows in it, then use **

DataTable.Clone

**
Work Done!

4

Free training…

5

Hi @Bh_P

Use “Read range Workbook” Activity/Use Excel Process Scope->Use Excel File->Read Range activities to store the whole excel in a Datatable.

image
image1197×390 22.6 KB

image
image1291×698 37.8 KB

Hope this helps!!

Regards,

6

@Bh_P

You can use this approach-

Use the “Excel Application Scope” activity to specify the Excel file you want to read. Within the scope, use the “Read Range” activity to read the data from the Excel file. Create a new data table using the “Build Data Table” activity. Define the columns based on the structure of your Excel data.Use a “For Each Row” activity to loop through each row in the read data table.Within the loop, use the “Add Data Row” activity to add the data from each row to the new data table you created.After the loop, you will have a data table that contains the data from the Excel file.

Thanks!!