Last post Oct 26, 2014 05:00 AM by Mikesdotnetting
Oct 24, 2014 06:03 PM|aktzc|LINK
I have a coded UI test project and an excel (.xlsx) file (for data set up) in that project. And say the first column in the sheet is 'Key'. Now I want to retrieve the whole row based on the given 'Key' column value. I have seen some documentation to use
LINQ and c#, but can anyone share a code snippet on this.
Thanks in advance!
Oct 26, 2014 05:00 AM|Mikesdotnetting|LINK
You can use the ACE provider to connect to the Excel file and query it using SQL.