How to write the headers from a DataTable just once into an Excel log file?




I need to save an Excel file with fixed headers on the first line of an Excel sheet and for each time the robot runs, the headers are not written a second time and only below data rows are written. This is my datatable:


So, somewhere in my workflow I have a BuildDataTable activity that will be then populated by add rows once information is written to it. Somewhere in the end of my workflow I have a sequence with an AddDataRow activity that will fill the data table recently created. For each row, there’s 5 columns and that means 5 variables with saved data ready to be written to a row.

In the very end of the workflow, I have an ExcelApplicationScope activity:


The problem with the AppendRange activity is that I of course don’t have an AddHeaders option similar to the following example:

Basically, I think that what I need to know is where and how to write the headers in the workflow?


Solved by adding an ExcelWriteRange activity inside the ExcelApplicationScope with the AddHeaders option checked!