Using Excel

2 posts, 0 answers
  1. Enoch
    Enoch avatar
    3 posts
    Member since:
    Apr 2012

    Posted 25 May 2012 Link to this post

    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?
  2. Stoich
    Admin
    Stoich avatar
    1 posts

    Posted 28 May 2012 Link to this post

    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
Back to Top