Excel scope

Help
1

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

0c8b8b7574816b4fdc062844c6b61724
0c8b8b7574816b4fdc062844c6b617241010×515 148 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)

2

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

Cheers…

3

is that working buddy

Cheers