Hello everyone!
Recently I have had several issues using excel activities, there is an error that appears randomly when automation is processing excel activities (read range, write cell, write range).
I tried to solve it upgrading the last version but this action hasn’t solve the issue
Neither class nor modern activities works because the error keeps appearing.
-Office is activated
-UiPath is licensed
does someone have an idea about how to solve it?
23.4.0-beta.12701+Branch.release-v23.4.0.Sha.f28ab212a5325cf466c152fb914c55858f5a423c
Source: Write Cell
Message: Failed setting the current sheet to: Validaciones in workbook: Y:\Robot_Sophos\RPADesarrollo\CargaMasiva_RPA\Data\Temp\PruebasCesar\0167-1037-3T2022_Carga_Masiva.xlsx. Original error message: Exception from HRESULT: 0x800AC472
Exception Type: UiPath.Excel.ExcelException
UiPath.Excel.ExcelException: Failed setting the current sheet to: Validaciones in workbook: XFILE . Original error message: 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 exception 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)
