web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power automate Desktop...
Power Automate
Unanswered

Power automate Desktop failed to write into excel

(0) ShareShare
ReportReport
Posted on by 10

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.pngScreenshot 2023-04-24 170010.png

 
 

 

 

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @zi_xi_l 

     

    is the csv data is large ?

  • julia5306 Profile Picture
    31 on at

    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.

  • zi_xi_l Profile Picture
    10 on at

    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

  • zi_xi_l Profile Picture
    10 on at

    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 Profile Picture
    10 on at

    csv file was download from another system, according the date download file size are different but format are same

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    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 Profile Picture
    10 on at

    Thanks a lot Nived N I have closed all other application, but same error happened

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 227 Super User 2026 Season 2

#2
David_MA Profile Picture

David_MA 213 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 151

Last 30 days Overall leaderboard