I am a new StudioX user (current on the trial version)… attempting to work my way through the tutorials. The second tutorial calls for me to Extract table data and add it to an Excel worksheet, then “format” the worksheet data. However, the action type “Format Range” is not available in my list.
This is frustrating for me as I am trying to experience what this product has to offer… and I am stuck. I do not want to waste my time with other tutorials if they too include roadblocks.
How do I proceed from here? Please advise.
Jason Peterson
Hello Jay, can you please show us the package version that your project is using ? Click on manage packages and do a print screen. The issue is that depending on what you selected during the installation process you might get more frequent or less frequent updates. Some of this updates will be breaking changes or some will be bug fixes or activity name changes.
then the activity would be named format range. if you would be using the latest beta packages the naming would be different ( I know confusing , but the name change came as a suggestion from one of our 3’rd party usability tests )
I would recommend that for future you spend a bit of time exploring the different activities that are under each category because regardless how they are named the descriptions stay the same
Here are the packages I currently have. I did install two based on feedback from others on the forum, but they did not provide the Format Range / Format Cells actions.
Can you please check the Include prerelease checkbox and update the Excel activities package the 2.7.2 was published 11/8/2019 3:03:09 PM and I don’t think that the format range / cells was included in that release
click on the blue arrow to update the packages.
19.10.4 of studiox is the first version, preivew, that had been improved and changed a lot since now, 20.4
Cannot seem to get past this issue. Trying to update, and I get an error.
19.10.4+Branch.support-v2019.10.Sha.fe819a658cad0585a64d2f8af94fad5c30b8d122
Method ‘GetActivityArguments’ in type ‘UiPath.Mail.Activities.Design.CommonScenarios.MailForeachContext’ from assembly ‘UiPath.Mail.Activities.Design, Version=1.8.3.0, Culture=neutral, PublicKeyToken=null’ does not have an implementation.
Error: System.TypeLoadException: Method ‘GetActivityArguments’ in type ‘UiPath.Mail.Activities.Design.CommonScenarios.MailForeachContext’ from assembly ‘UiPath.Mail.Activities.Design, Version=1.8.3.0, Culture=neutral, PublicKeyToken=null’ does not have an implementation.
at UiPath.Mail.Activities.Design.Services.BusinessPackageDescriptor.get_ContextDefinitions()
at UiPath.Studio.Plugin.Workflow.Services.ExpressionService.LoadProviders(IAssemblyContainer assemblyContainer)
at UiPath.Studio.Plugin.Workflow.Services.SecondDomainLoaderService.LoadFromContainerAsync(IAssemblyContainer assemblyContainer)
at UiPath.Studio.Plugin.Workflow.Services.Interfaces.ISecondDomainLoaderService.LoadFromContainerAsync(IAssemblyContainer assemblyContainer)
at UiPath.Studio.Plugin.Workflow.Services.Proxies.SecondDomainLoaderServiceProxy.LoadFromContainerAsync(IAssemblyContainer assemblyContainer)
at UiPath.Studio.Plugin.Workflow.Project.Services.ProjectLoaderService.<>c__DisplayClass31_0.<b__0>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Plugin.Workflow.Project.Services.ProjectLoaderService.d__29.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Plugin.Workflow.Shared.Project.BaseWorkflowProjectFactory.d__57.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Core.CommonServices.ProjectServiceBase.d__35.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Core.Services.Packaging.PackageOperationWithReload.d__8.MoveNext()
— End of stack trace from previous location where exception was thrown —
at UiPath.Studio.Core.Services.Packaging.PackageOperationWithReload.d__8.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Core.Services.Packaging.PackageOperationWithReload.<>c__DisplayClass5_0.<b__0>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Shared.MVVM.Services.DispatcherService.<>c__DisplayClass14_0.<b__0>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Shared.MVVM.Services.DispatcherService.d__14.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Core.Services.Packaging.PackageOperationWithReload.d__5.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at UiPath.Studio.Core.Services.Packaging.PackageOperationUpdate.d__3.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Shell.Services.ProjectContextService.<>c__DisplayClass9_0.<b__0>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Shared.Utilities.WindowCommandsExtensions.d__4`1.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.PackageExplorer.UI.ViewModels.PackageExplorerViewModel.d__155.MoveNext(), HResult -2146233054
Glad the excel worked. Although what I’m about to say sounds creepy if I were you I would try and recreate the workflow using some of the latest packages. Some of the StudioX specific activities are found in the latest versions and I don’t know what my colleagues from the Academy have prepared for week 2 and so on but I’m willing to bet that they will cover the new activities .
please upgrade to 20.4 as some of the activities do not work with 19.10.4 and upgrading only the packages could result in some errors because of the breaking changes since then
I am already registered… using the Trial. Is there a direct link to the resourceCenter?
Why do I need to re-register? Then I will have two trial licenses.
)
the 2.7.2 was published 11/8/2019 3:03:09 PM and I don’t think that the format range / cells was included in that release 
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123