Microsoft.Office.Interop.Excel error

Feedback Activities
, , ,
1

Hello All,

I am getting error while using excel interop in invoke code activity.

Details:
License Type: Community (Trial Enterprise activated)
Studio Version: 2023.6.1
UiPath.System.Activities : 23.4.3
UiPath.UIAutomation.Activities : 23.4.7

I am getting this error only for Windows Project. Same code working fine for Windows-Legacy

Error Message:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'office, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. The system cannot find the file specified.   at UiPathCodeRunner_132fd50edc3849689271284781c39225.Run()
	--- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Span`1& arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
   at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args)
   at UiPath.Activities.System.Utilities.InvokeCode.CompilerRunner.Run(Object[] args)
   at UiPath.Activities.System.Utilities.InvokeCode.NetCodeInvoker.Run(String userCode, List`1 inArgs, IEnumerable`1 imps, Object[] args)
   at UiPath.Core.Activities.InvokeCode.Execute(CodeActivityContext context)
   at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
   at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
   at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

InnerExceptionMessage:
Could not load file or assembly 'office, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. The system cannot find the file specified.

Let me know if any other detail is required.

@loginerror @Pablito

4

@AkshaySandhu

It’s better you share the exact inner Exception of the Invoke Code, by this above it will not be understand what part of the code got error

Thanks,
Srini

5

Added InnerException message in post now.

6

Hi @AkshaySandhu

Would you mind sharing a zip of a sample, dummy file that reproduces this issue for you?