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?

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

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

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.