span8
span4
span8
span4
I am writing Data with the Excel Writer to a Excel Template.
In this template I have defined Named Ranges.These ranges only consist of 1 Cell (e.g.PrjNr =Schachtblatt!$G$5)
The Problem is that FME writes to the Cell G6 (one cell below my named range)
Has anybody a solution for this Problem ?
Thanks
Hans
Hi@hansgm,are you truncating on write?This articledetails 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
Hi@egomm!In my experience,if you set theTruncate Name Rangeparameter toYes,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.
© 2019 亚搏在线Safe Software Inc |Legal