Excel automation using formulas

formula in excel

Hi @priyankavivek,

ExcelFormula.xaml (5.1 KB) ExcelFormula.xlsx (9.3 KB)

Thanks!

You can copy the formula you have and assign it to a string and use write cell activity to get the value in the required cell and then use auto fill range to get the values in all the rows.

1 Like