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

Issue with Excel sheet access from Test studio

3 Answers 43 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Aneesh
Top achievements
Rank 1
Aneesh asked on 06 Jun 2014, 10:13 AM
Hi Team,

I'm trying to access excel sheet from test studio by using the code,

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

But it returns the error message as "Cannot find the interop type that matches the embedded interop type 'Microsoft.Office.Interop.Excel.Application'. Are you missing an assembly reference? "

I have added the .net assembly for Excel from the location "C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.Office.Tools.Excel"

Can you please tell me how to solve this issue ?

Thanks & Regards
Aneesh

3 Answers, 1 is accepted

Sort by
0
Boyan Boev
Telerik team
answered on 11 Jun 2014, 07:09 AM
Hello Aneesh,

Thank you for contacting us.

'Microsoft.Office.Interop.Excel.Application' is a 'type' so you can't use it like a method.

Here is a fast Google search on how you can access the Excel from code.

Hope this helps.

Regards,
Boyan Boev
Telerik
 
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
0
Aneesh
Top achievements
Rank 1
answered on 12 Jun 2014, 12:26 PM
Hi Boev,
Thanks for the replay,
I have downloaded the new dll for Microsoft.Office.Interop.Excel.dll for .net assembly and the issue got resolved. in fact i believe the step is correct.
 Microsoft.Office.Interop.Excel.Application mobjExcelApp = new Microsoft.Office.Interop.Excel.Application();
0
Boyan Boev
Telerik team
answered on 13 Jun 2014, 11:31 AM
Hello Aneesh,

Glad to hear that. 

If you need further help, please let us know.

Regards,
Boyan Boev
Telerik
 
The New Release of Telerik Test Studio Is Here! Download, install,
and send us your feedback!
Tags
General Discussions
Asked by
Aneesh
Top achievements
Rank 1
Answers by
Boyan Boev
Telerik team
Aneesh
Top achievements
Rank 1
Share this question
or