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
3 Likes

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

6 Likes

Hi,

I want print data into same excel with another Sheet with headers using Append range Activity

So for this any Solution

You can write your header in the build data table -the white space
image

I have around 25 columns is there yar, now how can I do it

Just create 25 columns in build data table and enter headers in the white cell space