Linq code to get specific value in excel

LinqError 4
Hello i waqnt to extract values from cell

For eg:if input is akash i need to get phone number and email

@sathya_auto

You just need to use filter datatable…that also will do…or lookup datatable that also will do

No need of linq at all

cheers

Hi @sathya_auto

=> Use read range workbook activity to read the excel and store in a datatable.
=> Use for each row in datatable activity to iterate the rows in the datatable.
=> Inside for each insert the If condition to check the condition

- Condition -> CurrentRow("Name").equals("Akshay")

=> In then block give the assign activities and create two variables like PhoneNum and Email.

- Assign1 -> PhoneNum = CurrentRow("Phone").toString
- Assign2 -> Email = CurrentRow("Email").toString

In the PhoneNum and Email variables contains the value of Phone and email of Akshay

Hope it helps!!

than you anil

Cheers

1 Like

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