Filter excel to get data of only first row

Help
,
1

I have situation where i have " OR " condition with Company Name,Regd No, Partial Name ,Full Name . to fetch Column E and column F data.

If you see Column E and Column F have same data. i need to fetch only ID One and ID Two of first row.
can this be achieved ?? Please guide me…

sample
sample1129×156 33.3 KB

Thanks

2

Hi @Tabish_Faridi,

Follow the below steps.

  • Use Read range within Excel application scope.
  • Use Assign StringIDOne = Datatable1.Rows(1)(“ID One”).tostring
  • Use Assign StringIDTwo = Datatable1.Rows(1)(“ID Two”).tostring
3

This didn’t workout because those row i am getting after applying select query , so the value returning out of it is dataRow type from this data row how we can extract the value ??

Please reply…

4

If it is array of Datarow, use the below code.

  • Use Assign StringIDOne = arrDatarow(1)(“ID One”).tostring
5

Thanks Vivek, It is arr of dataRow but still it is not working…

Thanks for your quick reply.

6

You can use arrDataRow(1).Item("ID One").ToString

1 Like
7

Are you getting any error