This is a migrated thread and some comments may be shown as answers.

Using Excel

1 Answer 24 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Enoch
Top achievements
Rank 1
Enoch asked on 25 May 2012, 06:31 PM
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?

1 Answer, 1 is accepted

Sort by
0
Stoich
Telerik team
answered on 28 May 2012, 09:52 AM
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
Quickly become an expert in Test Studio, check out our new training sessions!
Test Studio Trainings
Tags
General Discussions
Asked by
Enoch
Top achievements
Rank 1
Answers by
Stoich
Telerik team
Share this question
or