How to get formula in a cell

[AjeeshJohn]

Hi

I assigned a formula in a cell in my template.I need to get the formula in the cell.How to get that

[shakeel.faiz]

Hi,

You can use Cell.Formula property.

Please use the following code, it will copy cell a1 formula to string variable

e.g

Cell al=…;

string formulaA1= a1.Formula;