Hello i waqnt to extract values from cell
For eg:if input is akash i need to get phone number and email
Hello i waqnt to extract values from cell
For eg:if input is akash i need to get phone number and email
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.