Use Excel File card throws an exception when used in a loop

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?

image

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 -

Hello,

We encountered this issue also in our internal testing and we made a fix for it. It should be available in our next release :slight_smile:

Regards,
Dragos.

2 Likes

Perfect! Thanks for the update @dragos.suma
Now am eager for the the next release :slight_smile:

is this because of that property ‘Reference as’ being always the same?