Auto fill range error with dynamic variable

[Soudios (Sou)]

20.4.1

Source: Auto Fill Range

Message: La méthode AutoFill de la classe Range a échoué.

Exception Type: UiPath.Excel.ExcelException

RemoteException wrapping UiPath.Excel.ExcelException: La méthode AutoFill de la classe Range a échoué. —> RemoteException wrapping System.Runtime.InteropServices.COMException: La méthode AutoFill de la classe Range a échoué.
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32 aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.AutoFill(Range Destination, XlAutoFillType Type)
at UiPath.Excel.WorkbookApplication.<>c__DisplayClass103_1.b__0()
at UiPath.Excel.ExcelContextHelper.Execute(Action action, ExcelContext context, Object contextParams)
— End of inner exception stack trace —
at UiPath.Excel.Activities.ExcelInteropActivity`1.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

[prasath_S]

Hi @Soudios

What is the value coming in NbLignes variable

make sure it is not empty or less than 2.

Thanks

[Soudios (Sou)]

hi @prasath_S

Yes it was the issue, i had less than 2.

Thank you