Hi All,
I'm trying to test desktop flow on Power Automate Desktop.
What I want to automate is scraping web page and save it in Excel.
When saving Excel, I got an error like below but actually the excel file was saved on specified location well.
I don't know why this error has been occurred. please let me know some guidance to resolve this error.
[Error Msg]
Failed to save Excel document 'C:\Users\demouser\OneDrive - Contoso\Demo1\Demo1_Result_마이크로소프트.xlsx'.
[Error Details]
Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Failed to save Excel document 'C:\Users\demouser\OneDrive - Contoso\Demo1\Demo1_Result_마이크로소프트.xlsx'. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException: SaveAs method of Workbook class failed
--- End of inner exception stack trace ---
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.InvokeMethod(Object o, String methodName, Object[] methodArgs)
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.SaveExcelInstance(Object activeWorkbook, String workbookName, FileVariant documentPathSafe, SaveExcelEnum saveSafe, ExcelSaveAsFormatEnum saveAsFormatSafe, String xmlMapName)
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.SaveExcel(Variant excelInstance, Variant documentPath, Int32 save, Int32 saveAsFormat, String xmlMapName)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.SaveExcel.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)
[screenshot]
Any comments would be appreciated.