How to read excel 1 row id 4 row column

Hi experts,
anyone could help me how to read one row in vendor id and read entire 4 column in excel sheet



1 Like


You can use read range activity that gives us a datatable…named out_dt and enablr the property add headers as well
Now use a assign activity to get that row alone for all columns like this
Out_datarow = out_dt.Rows(0)
Where 0 is the row index you want buddy @Abubakkar

This would give a variable with type datarow which will have all the cell value of all columns

Then you can use add datarow activity to add that datarow to any table you want by passing this variable out_datarow as input to the property datarow… @Abubakkar

Thats all buddy you are done…
Cheers…kindly try this and let know whether this works or not buddy @Abubakkar

1 Like

Thanks @Palaniyappan
it’s very helpful for me. I’ll try this solution buddy after I’ll let you know :+1::+1::+1:

1 Like

Did that work buddy @Abubakkar