Pfa Attached the screenshot,where on the basis of EAN no,i have to get complete row details.
I thought of reading the complete excel and then thru some querry get complete row somehow.
Extract the datatable from the excel sheet using “Read range” activity inside Excel Application Scope. Let’s say your datatable variable is dtExcelTable and the row variable for the row you need is ‘row’. Once you have this table, use assign activity and do this:
@prateekjain1992
Make sure that the variable type of the “row” variable is [DataRow].
After that, you will be able to play around with the “row” variable like row(“Size”).ToString or row(3).ToString to get the value of the Size column.
As @hojoong.kim said, you have to declare the “row” variable as a [DataRow] variable first. Using this DataRow object, you can access the cell values either as row.item(“EAN Code”)/row.item(2) OR merely as row(“EAN Code”)/row(2) as mentioned above.
NOTE: the indexes in the DataRow object starts with 0. Hence the index 2 denotes “EAN Code”.