Get value from excel

Help
1

i have particular column in excel sheet.

i want value from that column for every row and that value i have to use in application.

2

Hi @Ananya1
use for each loop in datatable

row(“ColumnName”).ToString

Thanks
ashwin S

3

Fine
Hope these steps would help you
—use excel application scope and pass the file path as input
—inside the scope use READ RANGE activity and get the output with a variable of type datatable named dt
—then use a FOR EACH ROW activity and pass the above variable dt as input
—inside the loop use a assign activity like this
str_input = row(“yourcolumnname”).ToString
—now use OPEN BROWSER activity and mention the url of the web page we want to process this input
—then inside that we can use this string variable

Cheers @Ananya1

4

@Ananya1

You can try below expression to read values from particular column.

  columnDT = yourDT.DefaultView.ToTable(False,"ColumnName").CopyToDataTable
5

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