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.
Append range will not add headers…you need to use a write range or a prebuilt template to populate the headers
Cheers
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.
