New answers tagged excel
Just use an Excel library to load data from Excel files and use that data in your Asserts? C# and Excel: http://stackoverflow.com/questions/657131/how-to-read-data-of-an-excel-file-using-c C# and Asserts: https://msdn.microsoft.com/en-us/library/microsoft.visualstudio.testtools.unittesting.assert.aspx
solution create a "summary" worksheet that connects all related worksheets this concept works for any data with a shared PK (primary key) all we're really doing is using standard VLookup functionality of Excel, but with an important twist instead of hard coding our VLookups we'll use Excel's INDIRECT function to execute our VLookups based on column ...
solution use the Excel Address function
Top 50 recent answers are included