Hi @hansgm ,

Please, see this link Template Excel And tell me if is good your problem.

Thanks,

Danilo

Hi @hansgm, are you truncating on write? This article details more on how to write using a template file.

So it is correct behaviour that if Truncate Named Range is set to yes, the output is written out one row below the named range?

I don't want to truncate as this loses the formatting in the first cell written, I guess I could put my named ranges one row above where I want the data to start writing but this doesn't seem very logical.

For my workflow, I cannot style in the writer so need to use template files to define the styles needed

https://knowledge.safe.com/questions/85729/excel-formattingstyling-with-dynamic-schema-defini.html

Hi @egomm! In my experience, if you set the Truncate Name Range parameter to Yes, it should replace the data in the existing named range (i.e. the existing named range begins on cell A1, it should clear the existing data in the named range and start writing at A1). Are you experiencing something different?

Feel free to share your workspace (.fmwt would be great, Save as Template) to better help us understand what's happening with your styling.