Skip to main content
  • EN

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 ,

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.

Hi @hansgm ,

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

Thanks,

Danilo

@danilo_inovacao

 

Thanks for answering but that's not what my Problem is.

 

 

 

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

Thanks for the tip!

 

I changed to "truncating existing named ranges = yes" and the data is now written to the correct named ranges.

 

But now all the formatting of the cells is deleted!

 

Is there a option to keep the formatting too ?

 

 

Thanks

 

Hans

 

 

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

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.

Reply


Community Stats

30,162
Posts
114,483
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.