Hi everyone,
I'm having some trouble in a Flow that I made which reads from a .CSV, separates all the columns, and applies each separated column into a new .XLSX file, but every time that I try and run the Flow it gives me a "out of memory error" when reading a column with a lot of text. I placed the error message at the end.
If anyone know what I need to do, please help.
Thanks in advance.
Ryzen 5 5600H
16GB Ram
500Gb SSD
Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Failed to write to Excel. ---> System.Reflection.TargetInvocationException: The target of an invocation threw an exception. ---> System.OutOfMemoryException: There are not enough memory resources to complete this operation. (Exception from HRESULT: 0x8007000E (E_OUTOFMEMORY))
--- End of internal exception stack trace ---
in System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
in System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
in System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)
in Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.SetProperty(Object o, String propertyName, Object value)
in Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.WriteToExcel(Variant excelInstance, Variant startCol, Variant startRow, Variant valueToWrite, Int32 writeMode)
--- End of internal exception stack trace ---
in Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.WriteToExcel.Execute(ActionContext context)
in Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)
