Eduardo Bernabe Sacahui Diaz
September 26, 2016 20:45 NONE
Hello !!! Friends!!! I have so far two assigns and a for each and I am trying to get the sheet name or names of an specific workbook. thanks for the help.
====first assigng ====
myinfo = new Workbookinfo()
- this variable type is classexcelActivities.woorkbook
also tried the interop.excel.workbook -
====second assing ====
ListofSheets = myinfo.getSheetList(mypath.tostring)
- this variable type is a list of strings -
====and my for each ====
for each item in listofsheets
log meesage = Item
- this log message is an info log message -
But its throwing me this error:
System.Xaml.XamlObjectWriterException: Cannot create unknown type ‘{http://schemas.microsoft.com/netfx/2009/xaml/activities}Variable({clr-namespace:ClassExcelActivities;assembly=ClassExcelActivities}WorkbookInfo)’.
at System.Xaml.XamlObjectWriter.WriteStartObject(XamlType xamlType)
at System.Xaml.XamlWriter.WriteNode(XamlReader reader)
at System.Xaml.XamlServices.Transform(XamlReader xamlReader, XamlWriter xamlWriter, Boolean closeWriter)
at System.Activities.XamlIntegration.FuncFactory1.Evaluate() at System.Activities.DynamicActivity.OnInternalCacheMetadata(Boolean createEmptyBindings) at System.Activities.Activity.InternalCacheMetadata(Boolean createEmptyBindings, IList
1& validationErrors)
at System.Activities.ActivityUtilities.ProcessActivity(ChildActivity childActivity, ChildActivity& nextActivity, Stack1& activitiesRemaining, ActivityCallStack parentChain, IList
1& validationErrors, ProcessActivityTreeOptions options, ProcessActivityCallback callback)
at System.Activities.ActivityUtilities.ProcessActivityTreeCore(ChildActivity currentActivity, ActivityCallStack parentChain, ProcessActivityTreeOptions options, ProcessActivityCallback callback, IList1& validationErrors) at System.Activities.ActivityUtilities.CacheRootMetadata(Activity activity, LocationReferenceEnvironment hostEnvironment, ProcessActivityTreeOptions options, ProcessActivityCallback callback, IList
1& validationErrors)
at System.Activities.WorkflowInspectionServices.d__3.MoveNext()
at System.Collections.Generic.List1.InsertRange(Int32 index, IEnumerable
1 collection)
at UiPath.Executor.WorkflowTracking.GetAllActivities(Activity activity)
at UiPath.Executor.WorkflowTracking.SetTrackingProfile(Activity activity, LogLevel logLevel)
at UiPath.Executor.WorkflowTracking.SetProfile(Activity activity, LogLevel logLevel)
at UiPath.Executor.RobotRunner.InitWorkflowApplication(JobModel job, LogLevel logLevel)
at UiPath.Executor.RobotRunner.OnInvokeJob(String jobInfo)
Thanks…!!!