How to add headers in append range

excel

#1

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

#2

Put an if condition as

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

Regards


#3

@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.