Excel writer loosing headers when writing to named range

Hi @p.jeremie,

It looks like in the Excel writer parameters, under Output Field Names,

"If no template file is used, this parameter has an effect only if the sheet or named range is being created or has been dropped or truncated prior to insertion. Otherwise, attribute names will not be added to existing worksheets or named ranges."

so you might be able to try using a template that contains the named range and checking this parameter to Yes to write out header names, or experiment with creating or truncating named ranges depending on your input data.

Hope that helps! Maybe the Community has more ideas to share as well? Always open to other ideas! (:

@jovitaatsafe thanks for the answer, but I'm not sure to understand correctly.

I don't have a template in my workspace but I truncate the named range. So the parameter should be taken into account :

• yes and the attribute names should be written in the named range
• no and they should not be written (this is what I want, so I chose no)

But when selecting no the headers (outside of my named range !) are lost.

Second point, I don't see how I can use a template in my case because I have a tab with an history that I want to complete each time the workspace is executed, therefore I think the only way is to update the destination Excel file.