Interop.Excel.Application is not defined

Alex · December 1, 2017, 9:59am

Hi,

I’ve tried importing the Microsoft.Office.Interop.Excel namespace, then within an Invoke code activity putting the following:
Dim xl As Microsoft.Office.Interop.Excel.Application

However, I get the following error message:

Main has thrown an exception

Source: Invoke code

Message: Error compiling code
error BC30002: Type ‘Microsoft.Office.Interop.Excel.Application’ is not defined. At line 1

Exception Type: ArgumentException

System.ArgumentException: Error compiling code
error BC30002: Type ‘Microsoft.Office.Interop.Excel.Application’ is not defined. At line 1

But Intellisense in Invoke Method window gives Microsoft.Office.Interop.Excel.Application namespace.

Did something solve this problem?

Thank you.

code_monkey · December 5, 2017, 9:52pm

I am also curious about this.

Manel · January 15, 2018, 3:28pm

Hi Alex,

Were you able to solve the issue? thanks

vvaidya · January 15, 2018, 3:37pm

Do you have the below assembly in your xaml, if not add it manually and restart your project and try again.

Manel · January 15, 2018, 4:20pm

Thank you very much, after adding this line UiPath could find the reference.

fdolsky · March 13, 2018, 6:01pm

Hi Guys, I fixed that, as vvaidya mentioned, but have still the same issue: error BC30002: Type ‘Microsoft.Office.Interop.Excel.Application’ is not defined. At line 1

Before this fix, there was an error: Cannot find the interop type that matches the embedded type ‘microsoft.office.interop.excel.application’… Any Idea? Thanks.

LorVR · April 4, 2018, 9:05pm

Check if “Microsoft.Office.Interop.Excel” is not automatically added

xmlns:moie=“clr-namespace:Microsoft.Office.Interop.Excel;assembly=Microsoft.Office.Interop.Excel”

ronlobo · June 1, 2018, 9:48am

yes. adding the above assembly reference, workflow works fine. But when I edit the workflow in studio, this manually added reference getting deleted all the time. Please help.

amakundu · June 27, 2018, 11:12am

This works for me. Just wondering why this entry is not automatically entered by UiPath Studio in the xaml file.

bobpeers · September 6, 2018, 6:57am

Just hit this issue myself using Microsoft.Office.Interop.Outlook.

If I add the import using the UiPath UI (lower pane) then the reference is not added. I need to manually add the reference two places in the xaml file. Then after I make any edits to the invoke code section the xaml is overwritten and references are lost again.

xmlns:moie="clr-namespace:Microsoft.Office.Interop.Outlook;assembly=Microsoft.Office.Interop.Outlook”

Seems like an unpleasant bug and makes it almost impossible to import these references.

The thread is also unanswered in this thread
https://forum.uipath.com/t/how-to-set-the-name-space-and-assembly-references-for-uipath-file/22188/11

bradsterling · April 9, 2019, 4:21pm

Hi @bobpeers ,

Has this been resolved to your knowledge?

bobpeers · April 16, 2019, 9:07pm

Hi @bradsterling,
I wish I could help but to be honest I haven’t tried this in quite a while so I have no idea if it’s still an issue.

bradsterling · April 16, 2019, 9:24pm

@bobpeers - thanks for the response.

FYI for all others - I got around it by using ClosedXML.

Lottie · April 23, 2019, 12:47am

Hello, I am also trying to use this namespace, however, I cannot declare variables with type of Microsoft.Office.Interop.Excel.Range.Row, could you please help?

devKarthikeyanR · May 14, 2019, 3:00pm

@bobpeers
Please add a new variable to the Workflow of the type (Microsoft.Office.Interop.Outlook).

msangha80 · June 14, 2019, 1:16pm

Guys, I have added assembly reference and done this

xmlns:moie="clr-namespace:Microsoft.Office.Interop.Excel;assembly=Microsoft.Office.Interop.Excel”

still facing this error, any inputs to resolve this issue

loginerror · April 7, 2020, 1:57pm

Hi @msangha80

Welcome back!

Could you try these two topics and see if the solutions from there will help?
https://forum.uipath.com/search?q=%22BC31539%22%20status%3Asolved

Both will have a post that is marked as a solution.

Yoshi_Akiyama · May 25, 2020, 8:20am

If there is a paraticular assembly/namespace you would like to use, try checking if it is provided as nuget.
For this particular case, you can add the assembly from package manager by adding www.nuget.org as one of your nuget feed.
“https://api.nuget.org/v3/index.json” is the source value.