Question

Text above attributes in excel and csv files

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!

Userlevel 4

Hi

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

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

Userlevel 4

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

Sign up