cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adelevance1
Regular Visitor

Error when saving Excel

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]

adelevance1_0-1670205902625.pngadelevance1_1-1670205937080.png

 

 

Any comments would be appreciated.

 

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (6,353)