Both the Workbook and Excel version of Append Range do not have an option to add headers if they are not present and it’s going to append to the first row. To get around this, I am having to check whether the file exists to know whether to do a write range (which has the option) or use the append range, defeating the point of the fact that append range can create a file if it is not present.
I would ask that the Append Range activities be updated to include options to add headers when writing data to files.
Why you want Add Headers option to Append Range Activity ?
We are appending data to already existing data by using this Activity right. I guess no need of this option.
Because the workbook could not exist, meaning that a new workbook would be created and data added to it without the option of adding headers.
Directly from the documentation: If the sheet does not exist, a new one is created with the name indicated in the SheetName field.
Here’s an example file showing the issue. The output “Test.xlsx” will include data without the headers: Test_AppendToNonexistantWorkbook.xaml (7.2 KB)
Thank you for your suggestion. I added it to our internal ideas tracker for our team to consider.
Just to loop back - the modern Excel activities do not have this issue