Excel scope

Am trying to read multiple excels using read range under excels scope and storing into datatable. I67a32dbfab2edcec9602e577ca8d7c5e.zip (13.2 KB)

t is throwing error at read range activity.
Error throw:
ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
UiPath.Excel.ExcelException: Exception from HRESULT: 0x800AC472 ----> System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel._Worksheet.Activate()
at UiPath.Excel.WorkbookApplication.SetSheet(String sheetName, Boolean createNew)
— End of inner ExceptionDetail stack trace —
at UiPath.Excel.WorkbookApplication.SetSheet(String sheetName, Boolean createNew)
at UiPath.Excel.Activities.ExcelInteropActivity`1.BeginExecute(AsyncCodeActivityContext context, AsyncCallback callback, Object state)
at System.Activities.AsyncCodeActivity.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)

Buddy @Animesh_Sarma

Kindly use Kill process with processname as EXCEL after each excel file is opened and read
The reason you get this error is excel is getting accessed while trying to read the file or even because the office software might got some issue, reintall your excel and try buddy

Hope this would help you


is that working buddy