Here is the scenario that my business team is working on with StudioX.
They need to open each excel file saved in a folder and perform some operation with them.
But Use Excel File card throws an exception like the one below when it runs for the second time in the loop (For each file in folder)
Tried inserting the excel card in any loop for that matter, I came across the same problem again.
This seems like an bug to me. Suggestions anyone?
20.2.0-beta.108+Branch.release-v2020.2.0.Sha.8a477a3ff8e9d37d84fd97a9b453d655d8f9dddd Source: Use Excel File Message: Workbook closed. Please re-initialize the workbook. Exception Type: UiPath.Excel.ExcelException RemoteException wrapping UiPath.Excel.ExcelException: Workbook closed. Please re-initialize the workbook. at UiPath.Excel.WorkbookQuickHandle.CloseWorkbook() at UiPath.Excel.WorkbookQuickHandle.InitializeWorkbook(IExtendedWorkbookFactory workbookAppFactory) at UiPath.Excel.Activities.Business.ExcelApplicationCard.Execute(NativeActivityContext context) at System.Activities.NativeActivity.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)
Excel Card Issues.zip (64.2 KB) This is a sample project I made to replicate the scenario quick -
with two files in the data folder…
and the workflow like this…