How to automate excel formulas and perform double click on the bottom end of the formula cell

Every type of format will be informed before starting the automation if its an int or a specific date format or a string

well right now the excel i have is all of string (just a demo excel of 800k no of rows)

it contains all the data and the out put (im not sure if the formula will show for you too when you will open the excel file in your system , let me know if it doesn’t shows up)

here is the excel in 7zip file