While using the sort table activity, i am getting this error.
RemoteException wrapping System.ArgumentException: The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
at UiPath.Excel.Activities.ExcelInteropActivity`1.EndExecute(AsyncCodeActivityContext context,
IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context,
IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor,
BookmarkManager bookmarkManager)
@William_Blech_Sister I understood the workaround. Nevertheless, downloaded the example from forum and that too has the same exception, don’t know the issue. Anyways, thanks for your time.
@William_Blech_Sister Quite interesting, getting the same error for Insert Column but Delete Column is working fine. BDW, i am having WPS installed rather than MS Office. Hope it doesn’t make any diff
The error in your workflow is that in file ‘Book2’ you are trying to sort an Excel table that does not exist.
When UiPath copies data from ‘Book1’ to ‘Book2’ it copies just the data. It does not replicate the Excel Table. UiPath does not have an activity to create an Excel Table yet.