How can I display Excel Row Results in the Visual Studio Data Driven results window?

Question

Hello
Im using VS 2010 pre-release for C#.
I have an excel spreadsheet where I am using the Interop Library to read data from a spreadsheeet.
For each row read from the spreadsheet, I evaluate a result using Assert statements.
Now I want to be able to display the PASS/FAIL per row in the Visua Studio's Data Driven Result table.
is there a way to do this programmatically ? ( remember Im using Excel Interop)

thanks
J

j l · Answer

Hello Everyone I Solved my question... The original situation was that I am using Excel Interop to read/write data from a spreadsheet and compare string values received from a server against the static string values stored in the Excel spreadsheet. I also needed to switch in between tabs of the spreadsheet and change colors of cells ect. during the test. Example Excel Spreadsheet Data (stored on a local PC): Customer Name Account # CustomerID John Doe 0001 0 Jason Terry 0002 1 Jill Biden 0003 2 So if I requested Customer ID 0 from a Server it should return the same data as the spreadsheet: John Doe and 0001. The Excel strings and Server strings would match and that would be a Pass for that spreadsheet row. The problem was once I had the PASS/FAIL values for the string comparisons I didnt know how to feed that Excel Pass/Fail data back into Visual Studio's Results Window. So the solution is to have 2 Testmethods and Add a column called Pass/Fail Customer Name Account # CustomerID Pass/Fail John Doe 0001 0 Pass Jason Terry 0002 1 Fail Jill Biden 0003 2 Pass [TesttMethod1] { Do all of my Excel Interop Work Here: reading from cells change cell colors switch tabs string comparisons (against server returned data)  and write final Pass/Fail results to cells } [TestMethod2] { Assert.AreEqual(Pass TestContext .DataRow [Pass/Fail]); } Adding the 2nd method now allows my Excel spreadsheet row results to be shown in Visual Studio's Results Window. ~J