Skip to main content
Question

Writing to Excel tables and formatting


sofia
Contributor
Forum|alt.badge.img+5
  • Contributor

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!

2 replies

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • Evangelist
  • 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
danilo_fme wrote:

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!

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings