Issue with Excel sheet access from Test studio

[Aneesh]

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

[Boyan Boev]

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

 

[Aneesh]

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();

[Boyan Boev]

Hello Aneesh,

Glad to hear that. 

If you need further help, please let us know.

Regards,
Boyan Boev
Telerik