Formula needs to preserved while writing into Excel

Help Activities
, ,
1

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

2

Can you send sample excels of both?

3

@manishsoni0407,

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

4

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