Retrieve data from the merged column


#1

Hi Everyone,

I am trying to retrieve data from excel based on the condition ID = yes in an excel but the sheet is merged. Can anyone given idea how to retrieve all the data in a row where ID is equal to yes.

Unitinfo.xls (25.5 KB)

Thanks,
Ulaga


#2

Have you tried using Excel Application Scope with Read Range?. It should add your table into a DataTable. You can just filter your datatable from there.

Let me know if thats not what you are looking for.

Thanks,
Rammohan B.


#3

Hi @Rammohan91 i am able to get the datatable using readrange but the thing is i want the rows value of excel which have the Last key value = yes. I have highlighted that row in yellow.


#4

The ID value yes can be in any row in excel and struggling to get all the row values.


#5

@Rammohan91 I resolved this issue using Linq concept.