Question

In my workbench I write multiple data to one excel file. Only then you get different tabs in excel, but I want everything in one tab. With a nice overview of headings and lines in between. Does anyone know how to do this in FME?


ExampleThis is how I it get, with different tabs. And below is how I want it.

Example


2 replies

Badge +11

Perhaps this is a closer answer to your questionhttps://www.extendoffice.com/documents/excel/5017-excel-collect-data-from-multiple-sheets.html

Userlevel 3
Badge +17

This is possible but I would recommend not to do it except when there is no other option. I hate datasets like this.

WB 

You need to create a header feature, a row_number attribute, and rename all the other attributes to the column position. So rename Code to A, Status to B etc.

 

Then you need to merge the last features row_number to the second dataset and add this to the row_number of the second dataset.

 

The Excel Writer is set to:

Don't output attribute names, use attribute names as column position and Row number attribute = row_number.

 

I attached a working workbench.

 

 

 

 

Reply