How to Convert excel to DataTable in UIPath?

Help Studio
, , , , , , , ,
1

I want to add the data and column to the data table , any idea thanks ?
build DT

image

Excel data

image
image1419Ă—734 38.5 KB

2

You can use the Read range activity here and specify the range as “A1:B3” and you will get the output as datatable.

3

@srinath49 so I dont need to build a data table ?

1 Like
4

No need and no need to define range either if you just want to read everything on the sheet :smiley: Just assign output to a dt-variable

5

and how access each for ? @nicortak for example I want access the data from the output DT

6

how are we going to access each row like row(“filename”).toString is that automatic without building a datatable ?

7

Build is for when you need to manually design the columns.

Just use Read Range from Workbook Activities and it’ll put it into a DT for you, using the spreadsheet as the design of the DT.