Help me to write the some formula in to Excel cell through Invoke Code Activity

[Shaik_Sattar_Babu]

Hi Robot Masters

I have a Excel file contains large data like 10000 Rows. I want to write some excel formula to BN Column cells like BN2 to BN10000. I already wrote a code with UiPath Activities using For Each but bot taking more time to run the code.
So, Please help me with some Invoke Code

Thanks in advance

[Palaniyappan (Palaniyappan P)]

Hi

Welcome to UiPath forum

Have a view on thread for similar note and multiple solutions

Fastest way to write an excel formula into an entire column

Hi All, I have a simple solution for this and i tried with 3 lakh records and it worked for me. I used Invoke Code activity to do all this formula stuff. Here is the code which i used. obj = wb.Sheets.Add(Before:=ws, Count:=1, Type:=Microsoft.Office.Interop.Excel.XlSheetType.xlWorksheet) CType(obj, Microsoft.Office.Interop.Excel.Worksheet).Name = "Reversing Accruals" ws = CType(wb.Sheets("Reversing Accruals"), Microsoft.Office.Interop.Excel.Worksheet) ws.Activate() …

Cheers @Shaik_Sattar_Babu

[Shaik_Sattar_Babu]

Thank you @Palaniyappan

[Palaniyappan (Palaniyappan P)]

Glad it got resolved @Shaik_Sattar_Babu