Skip to main content
Solved

How can I create multiple tabs in an Excel Spreadsheet

  • January 4, 2016
  • 2 replies
  • 481 views
C

Dear All, I am new to FME and have little experience but I am stuck on the below and hoping somebody will be able to point me in the right direction.

Firstly, I have about 14 geo-database datasets that I am running through a clipper (for a particular boundary) and a number of other transformers before writing into an XLS. I want to find out which datasets apply to my area and produce a spreadsheet with multiple tabs, one for each dataset.

Secondly I want to know how to select only certain attributes from the applicable layer in the geo-database.

I would be greatful for any help offered.

Thank you

Best answer by erik_jan

Tabs in the Excel output are featuretypes on the Excel Writer.

So Either you define multiple writer featuretypes (by using the Add Featuretype from the Writer menu after creating the writer, or you use the Featuretype Fanout on the Featutetypeproperties dialog.

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

takashi
Celebrity
  • takashiCelebrity
  • January 4, 2016

If your goal is to create multiple worksheets for each source dataset, add an attribute that holds desired destination worksheet name to every feature and set it to the destination feature type name (i.e. worksheet name). In the Excel writer feature type properties dialog, you can set the attribute to the "Sheet Name" field. See also here: Setting Feature Type Fanout

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
erik_jan
Contributor
Forum|alt.badge.img+23
  • erik_janContributor
  • Contributor
  • Best Answer
  • January 4, 2016

Tabs in the Excel output are featuretypes on the Excel Writer.

So Either you define multiple writer featuretypes (by using the Add Featuretype from the Writer menu after creating the writer, or you use the Featuretype Fanout on the Featutetypeproperties dialog.

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.