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
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
0
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
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
0
Aneesh
Top achievements
Rank 1
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();
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
Hello Aneesh,
Glad to hear that.
If you need further help, please let us know.
Regards,
Boyan Boev
Telerik
Glad to hear that.
If you need further help, please let us know.
Regards,
Boyan Boev
Telerik