Question

Writing to Excel tables and formatting

  • 10 April 2018
  • 2 replies
  • 9 views

Badge

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

Userlevel 4
Badge +30

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

Badge

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!

 

 

Reply