Skip to main content
Question

Writing to Excel tables and formatting

  • April 10, 2018
  • 2 replies
  • 157 views

sofia
Contributor
Forum|alt.badge.img+5

Hi!

Does any one know of a good resource on formating FME output in excelfiles? I have, for example, an excel writer where I don't manage to get the rows that get written to land inside the table in my excel template. Instead the rows write themselves outside of the table, and then I have to go in manually to cut out and paste the rows into the table.

There are many other small things and fine tuning I would like to do with the way my excel file gets written. Another couple of formatting things I want to learn how to do are hiding columns, filtering on certain values (while making the data still available in the sheet) etc.

If you know of any, please recommend a good website,video or document where I can read more on these kinds of formatting tips and tricks!

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.

2 replies

danilo_fme
Celebrity
Forum|alt.badge.img+52
  • Celebrity
  • April 10, 2018

Hi @sofiamvalentin,

In Webinar section there is a important Topic about Tips for Automating Excel

With this Webinar is possible to do download the Workspaces used about in this Webinar.

I hope that this help you!

Thanks,

Danilo


sofia
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • April 10, 2018

Hi @sofiamvalentin,

In Webinar section there is a important Topic about Tips for Automating Excel

With this Webinar is possible to do download the Workspaces used about in this Webinar.

I hope that this help you!

Thanks,

Danilo

Thank you, I will check the webinar out!