Getting each element(from one column) from excel and entering it to a field in website

Help
1

how to access each element from a column in an excel sheet and enter those each element to a field in a website step by step?

2

Read excel file and store output in datatable
Then
Datatable.rows(rownumber).item(columnName).tostring
Use this in set text activity and increment row number

3 Likes
3

Hey @Pallavi_raj

solution worked for you ?

4

Hi @Pallavi_raj,

Use read range activity to get the data to Data Table.

Use for each row activity to loop the data.

Then inside row("columnname").Tostring to get the value of the column.
After getting value you can use type into or set text activity to write the data into website.

Regards,
Arivu :slight_smile:

4 Likes
5

Thank yu it worked!

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.