Power Platform Community Forum Thread Details

Hi,

I have sucessfully run web scraping several times, but suddenly PAD started to stop when it needs to write an Excel file. From a list of more than 1500 lines, it only writes a couple hundreds.

The error is the following:

Robin.Core.ActionException: Falha ao escrever no Excel. ---> System.Reflection.TargetInvocationException: O destino de uma invocação accionou uma excepção. ---> System.Runtime.InteropServices.COMException: Excepção de HRESULT: 0x800A03EC
--- Fim do rastreio da pilha de excepção interna ---
em System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters)
em System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
em System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)
em Robin.Modules.Excel.Actions.ExcelActions.SetProperty(Object o, String propertyName, Object value)
em Robin.Modules.Excel.Actions.ExcelActions.WriteToExcel(Variant excelInstance, Variant startCol, Variant startRow, Variant valueToWrite, Int32 writeMode)
--- Fim do rastreio da pilha de excepção interna ---
em Robin.Modules.Excel.Actions.WriteToExcel.Execute(ActionContext context)
em Robin.Runtime.Engine.ActionRunner.RunAction(String action, Dictionary`2 inputArguments, Dictionary`2 outputArguments, IActionStatement statement)

Can someone help me?

Categories:

Power Automate Desktop