Using Excel

[Enoch]

I want to use Excel for non-iterative data driven testing. I used the code sample from the user manual, and I pointed my project to the proper assembly (Microsoft.Office.Interop.Excel). I then put a "using" statement in my code. But when I try to run the script, it tells me that it cannot create an instance of the following:

Microsoft.Office.Interop.Excel.Application excelApp = new
Microsoft.Office.Interop.Excel.Application();

The specific error is c:\Users\enoch.ornstead\Documents\Test Studio Projects\Programming_testing\Excel integration.tstest.cs: Line 101: (CS0144) Cannot create an instance of the abstract class or interface 'Microsoft.Office.Interop.Excel.Application'
Any idea what I could be doing wrong?

[Stoich]

Hi Enoch,
since this is a .Net/C# error not strictly related to Test Studio. So you could search for information on the Internet related to resolving it.

I put this line of code in a test I created and I was able to run it successfully. Thus I'm not sure why you're having problems with it.

If you're still unable to make progress on this: go ahead and send us your entire test project and we'll try to make it work for you.
 
All the best,
Stoich
the Telerik team