Power automate Desktop failed to write into excel

Like (0) Share

Report

Posted on 24 Apr 2023 08:31:29 by zi_xi_l

Dear ,

I want to get data from one csv file and write into excel ,but happened flowing error:

Correlation Id: b7ba6c64-8245-429a-8a8a-3afa128dd132

Exception has been thrown by the target of an invocation.: Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Failed to write into Excel. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.OutOfMemoryException: Not enough memory resources are available to complete this operation. (Exception from HRESULT: 0x8007000E (E_OUTOFMEMORY))
--- 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.SetProperty(Object o, String propertyName, Object value)
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.WriteToExcel(Variant excelInstance, Variant startCol, Variant startRow, Variant valueToWrite, Int32 writeMode)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.WriteToExcel.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

whether can anyone help me ,thanks a lot !!!!!

Screenshot 2023-04-24 170058.png

Screenshot 2023-04-24 170029.png Screenshot 2023-04-24 170010.png

All responses (7)

Answers (0)

zi_xi_l 10 on 28 Apr 2023 at 07:56:18

Like (1)

Report

Re: Power automate Desktop failed to write into excel

Thanks a lot Nived N I have closed all other application, but same error happened
Nived_Nambiar 17,972 Super User 2025 Season 2 on 25 Apr 2023 at 02:19:49

Like (0)

Report

Re: Power automate Desktop failed to write into excel

Hi @zi_xi_l

Out of memory exception occurs when program tries to allocate more memory than OS allocates, it can be occured when another program allocates more memory than avaialble causing other programs to fail.

So i think when you were running the bot, other programs/processing were running as well which consumes more memory which cause the bot to stop due to out of memory issue
zi_xi_l 10 on 25 Apr 2023 at 01:46:59

Like (0)

Report

Re: Power automate Desktop failed to write into excel

csv file was download from another system, according the date download file size are different but format are same
zi_xi_l 10 on 25 Apr 2023 at 01:00:18

Like (0)

Report

Re: Power automate Desktop failed to write into excel

Hi julia5306,
Before I open the excel I added an action terminate process ,but it still doesn't work ,and I checked excel I did not set "read only"
Thanks & Regards,
zi_xi_l 10 on 25 Apr 2023 at 00:54:46

Like (0)

Report

Re: Power automate Desktop failed to write into excel

Hi Nived N,
I have ever ran this flow before,the last time csv file is larger than this time,but last time flow run successfully,but this time failed,I don not know why
julia5306 29 on 24 Apr 2023 at 10:03:48

Like (0)

Report

Re: Power automate Desktop failed to write into excel

Have you run this code before? It looks like you don't have a "Close Excel" action after the "Write to Excel", so Excel could be open in the background without displaying. If you open up task manager on your computer and press the "E" key, it will cycle through all programmes running starting with "E". If you see Excel in your task manager, close it using "End Task" and try running it again! You may have a hidden open instance of Excel, so when you open the spreadsheet again with this, puts the spreadsheet into "read-only" causing the action to fail.
Nived_Nambiar 17,972 Super User 2025 Season 2 on 24 Apr 2023 at 09:20:37

Like (0)

Report

Re: Power automate Desktop failed to write into excel

Hi @zi_xi_l

is the csv data is large ?