Skip to main content
Solved

How can I create multiple tabs in an Excel Spreadsheet

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.

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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
Contributor
Forum|alt.badge.img+19
  • takashiContributor
  • Contributor
  • 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

erik_jan
Contributor
Forum|alt.badge.img+17
  • 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.

Most helpful members this week

Community Stats

30,859
Posts
116,998
Replies
38,689
Members
Terms & ConditionsCookie settings

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
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.