How to add headers in append range



Hi, I used these steps below.

  1. Build data table - got columns
  2. Add data rows
  3. Under excel scope, append range
    However, how to add headers in append range? As there are no checkbox for me to tick


Put an if condition as

if(File.Exist(Your File Path)
Use Append Range
Use Write Range with check ing the header option



@Himanshu.joshi Hi, in my workflow i cannot use write range. As the append range is in the bottom of the loop thus it will keep adding the lines.