"body": {
"error": {
"code": "Excel.WriteToExcelError",
"message": "Problem while executing action 'WriteCell'. Failed to write into Excel. \r\n \r\nMicrosoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.ActionException: Failed to write into Excel. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC\r\n --- End of inner exception stack trace ---\r\n at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)\r\n at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)\r\n at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)\r\n at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.GetProperty(Object o, String propertyName, Object[] arguments)\r\n at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.WriteToExcel(Variant excelInstance, Variant startCol, Variant startRow, Variant valueToWrite, Int32 writeMode, String cellName)\r\n --- End of inner exception stack trace ---\r\n at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.WriteToExcel.Execute(ActionContext context)\r\n at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)\r\n"
}
Is this flow working fine on attended mode? - Yes, It is running without any error.
About workflow:
1. Email Auto trigger Excel Attachment
2. Save the excel to particular location
3. Run the desktop flow in un-attended mode (sign out)
4. In desktop flow 1st we execute the python code for ETL process.
5. Creates the transformed file in particular location
After this actions the flow is failing. Please find the error details above.
