Hello! I'm trying to write the values from several attributes into an excel file. I want all values on the same row, now I'm getting them in one row after another.
Any ideas on how to do this?
Regards,
Louise
Question
Writing Attributes to Excel
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi, yes aggregate them into one with the aggregator.
Thank you! But I don't really understand how this will help me. I want them on the same row but different columns. I have been trying to do this with setting which row to write on. Is there some way of specifying row and column? I have the 2014 version.
FME writes one feature per row in your Excel file, so the key is to have all the attributes in the same feature if you want them all on the same row. The Aggregator is one way of "accumulating" all the attributes from several features into one feature.
On the Excel writer you should then define the attributes in the order which they (the columns) will appear in the Excel file.