Assembly reference Error

[devi1 (devi)]

Hi People,

I am trying to use a simple ‘Lookup range’ excel activity in my uiPath project.

But I could not find it in activities pane, hence I tried to install UiPath.Excel.Activities package.

Could not see the required activities like lookup range, etc post installation. getting the below error.

“Could not load type ‘UiPath.Excel.ExcelCopyOptions’ from assembly ‘UiPath.Excel, Version=2.3.6682.26624, Culture=neutral, PublicKeyToken=null’.”

Help needed !

[ratndeepb (Ratndeep)]

Having a same issue but didn’t found any solution.
Could not load type ‘UiPath.Excel.ChangeMode’ from assembly ‘UiPath.Excel, Version=2.3.6682.26624, Culture=neutral, PublicKeyToken=null’.

System.TypeLoadException: Could not load type ‘UiPath.Excel.ChangeMode’ from assembly ‘UiPath.Excel, Version=2.3.6682.26624, Culture=neutral, PublicKeyToken=null’.
at System.Reflection.RuntimeAssembly.GetType(RuntimeAssembly assembly, String name, Boolean throwOnError, Boolean ignoreCase, ObjectHandleOnStack type)
at System.Reflection.RuntimeAssembly.GetType(String name, Boolean throwOnError, Boolean ignoreCase)
at System.Reflection.Assembly.GetType(String name)
at System.Xaml.Schema.XamlNamespace.SearchAssembliesForShortName(String shortName)
at System.Xaml.Schema.XamlNamespace.TryGetType(String typeName)
at System.Xaml.Schema.XamlNamespace.TryGetXamlType(String typeName)
at System.Xaml.Schema.XamlNamespace.GetXamlType(String typeName, XamlType typeArgs)
at System.Xaml.XamlSchemaContext.GetXamlType(String xamlNamespace, String name, XamlType typeArguments)
at UiPath.Project.XamlResolver.GetXamlType(String xamlNamespace, String name, XamlType typeArguments)
at System.Xaml.XamlSchemaContext.GetXamlType(XamlTypeName xamlTypeName)
at MS.Internal.Xaml.XamlContext.GetXamlType(XamlTypeName typeName, Boolean returnUnknownTypesOnFailure, Boolean skipVisibilityCheck)
at MS.Internal.Xaml.Parser.XamlScanner.ReadObjectElement_Object(String xmlns, String name, XamlScannerNode node)
at MS.Internal.Xaml.Parser.XamlScanner.ReadObjectElement(XamlName name, Boolean isEmptyTag)
at MS.Internal.Xaml.Parser.XamlScanner.ReadElement()
at MS.Internal.Xaml.Parser.XamlScanner.ProcessCurrentXmlNode()
at MS.Internal.Xaml.Parser.XamlScanner.DoXmlRead()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_EmptyElement>d__6.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementContent>d__12.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementBody>d__8.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementContent>d__12.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementBody>d__8.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_PropertyContent>d__13.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_NonemptyPropertyElement>d__11.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_PropertyElement>d__9.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementBody>d__8.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementContent>d__12.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementBody>d__8.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_PropertyContent>d__13.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_NonemptyPropertyElement>d__11.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_PropertyElement>d__9.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementBody>d__8.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementContent>d__12.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementBody>d__8.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementContent>d__12.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementBody>d__8.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementContent>d__12.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementBody>d__8.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_PropertyContent>d__13.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_NonemptyPropertyElement>d__11.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_PropertyElement>d__9.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementBody>d__8.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementContent>d__12.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_ElementBody>d__8.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.<P_Element>d__5.MoveNext()
at MS.Internal.Xaml.Parser.XamlPullParser.d__4.MoveNext()
at MS.Internal.Xaml.NodeStreamSorter.ReadAheadToEndOfAttributes()
at MS.Internal.Xaml.NodeStreamSorter.ReadAheadAndSortCtorProperties()
at MS.Internal.Xaml.NodeStreamSorter.MoveNext()
at System.Xaml.XamlXmlReader.Read()
at System.Activities.XamlIntegration.DynamicActivityXamlReader.Read()
at System.Activities.XamlIntegration.DynamicActivityXamlReader.Read()
at System.Xaml.XamlServices.Transform(XamlReader xamlReader, XamlWriter xamlWriter, Boolean closeWriter)
at System.Xaml.XamlServices.Load(XamlReader xamlReader)
at System.Activities.XamlIntegration.ActivityXamlServices.Load(XamlReader xamlReader, ActivityXamlServicesSettings settings)
at System.Activities.XamlIntegration.ActivityXamlServices.Load(XamlReader xamlReader)
at UiPath.Workflow.Designer.DesignerAddIn.LoadActivity(String file)
at UiPath.Workflow.Designer.DesignerAddIn.Load(String file)
at UiPath.Workflow.ViewModels.WorkflowViewModel…ctor(String workflowFile, IXamlLoadErrorService errorService, Boolean recovered)
at UiPath.Workflow.ViewModels.MainViewModel.OpenWorkflowInProject(String workflowPath, Boolean recovered)

[loginerror (Maciej Kuźmicz)]

Hi @ratndeepb

I will refer you to this post first:

Main has thrown an exception:message:job stopped due to unexpected process termination

Hi @rahuls Please post a sample workflow that is causing the issue. Also, please try this basic set of actions, it tends to fix a lot of issues of this type: Clearing these folders: %userprofile%\.nuget\packages %userprofile%\AppData\Local\UiPath\.cache (please keep a backup) Reinstalling Studio Restarting your machine

If the issue happens only when you run your process from Orchestrator but it works fine from Studio, the solution is slightly different.