Unable to create Excel Application Instance in Invoke Code activity

Scenario: Won’t able to create Excel Application Object in Invoke code. Though I use Microsoft.Office.Interop.Excel Namespace.

Steps to reproduce:

Current Behavior: error BC31539: Cannot find the interop type that matches the embedded type

‘Microsoft.Office.Interop.ExceI.AppIication’. Are you missing an assembly reference? At line O
Exception Type: Argumentaception
System.ArgumentException: Error compiling code
error BC31539: Cannot find the interop type that matches the embedded type

Expected Behavior: It should create an object for Microsoft.Office.Interop.Excel.Application

Studio/Robot/Orchestrator Version: Studio

Last stable behavior:
Last stable version:v2017.1
OS Version:windows7
Others if Relevant: (workflow, logs, .net version, service pack, etc):

2 Likes

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

1 Like