How to do Auto Fill Range Activity in Excel Automation?

Help
, ,
8

@ARahman

Steps to do

  1. Use assign activity and declare the variable of type string and assign the value as “=Sum(A2:B2)”
  2. Use excel application scope and provide the path of excel
  3. Then write cell Activity to write the formula in that one cell which will sum A2 and B2 cell
  4. Then use auto fill range to drag the formula to the end of the excel sheet data
3 Likes