Read data from excel sheet

Help
1

Hi everyone…

I tried to search for the answer before asking you here…

I have a case, I have to query record for particular data in web site…these data will coming from excel sheet which already saved in my local…
I need to read data from excel cell by cell and doing query in website…

Is that possible to do it ???

2

Hi,
you can use “read range” to get the data into a datatable and them use “For each Row” to iterate your data.

3

@Hanan_Saad Have a look Here and download zip file so you can get on idea

4

Thanks , it seems very useful post…

1 Like
5

Hi @indra , I have concern here, I have 4 columns and used type into activity
but i am getting issue…

1
11152×709 29.5 KB

the sequence for columns in website are changing, means user can changing the order of columns by drop and drag…so that value for field which getting from excel sheet will be wrong…

do you know how can fix this??
how can match each columns in excel with column in website