Formula needs to preserved while writing into Excel

I have 2 excel ,
Excel One : Column A contains formula and some data along with some data in another column
Excel Two : Report

What i need to do here is , preserve the formula of Excel One – > Column A and delete all the content.
Read Excel Two and paste the content from Column B1. since formulas are preserved in Excel One Column A data should be auto populated.

Can anyone propose the solution

Can you send sample excels of both?


Can you try to read excel by selecting preserve format property of Read Range activity?

I did that but it takes forever to read the excel and never comes out.