Add Headers To Append Range in Second Sheet (Excel)

Hi All,

I have an requirement where I need to add headers to second sheet of excel . I am using append range but I am getting the data without headers. I want to add the headers in the second sheet similar to sheet 1
QA_AutomationOutputFile_02-Nov-2023.xlsx (8.0 KB)
of excel while using the append range activity.

1 Like

@marina.dutta

Append range will not add headers…you need to use a write range or a prebuilt template to populate the headers

Cheers

1 Like

You can use the Write Range activity to write the headers to the second sheet.

Hi, you use append range and if you want to add headers in it then you have to uncheck add headers options while read range activity and then this range use to write in append range it will get headers also

use dt.clone to create a copy of the the datatable with headers only
e.g. dt2 = dt.clone in assign activity

then write dt2 to sheet2. remember to check add headers

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.