Skip to main content
  • EN
Hello!

 

I was wondering if it's possible to create a standard text above the different attributes in excel or csv files?

 

Here's an example of how it should look like. Two rows is standard and the attribute names will start at row four.

 

 

Thank you!
Hi

 

 

If I'm not mistaken, it should be possible using a template file with named ranges.

 

 

There is more info in the help: http://docs.safe.com/fme/html/FME_ReadersWriters/FME_Readers_Writers.htm#xlsx/XLSX_writer.htm

 

 

David
Hi again!

 

I really tried to figure this out, but i'm not quite sure what kind of template I should use.

 

Is it possible to give me an example of how you're thinking of this issue?

 

 

Best regards

 

Fredrik
Hi

 

 

You create the template file yourself, filling in fields and formatting it as you like. You then define so-called named ranges (e.g. http://spreadsheets.about.com/od/excelformulas/ss/2011-01-15-excel-range-name-overview.htm) which defines where FME will later write the values. You save this Excel file and specify it as a template file for your Excel writer.

 

 

There is also a lot of good information here: https://www.youtube.com/watch?v=pJrsV34VdFc

 

 

David

Reply


Community Stats

30,108
Posts
114,294
Replies
37,743
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.