User is trying to write out an explicit table https://support.microsoft.com/en-au/office/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c rather than a block of data styled as a table. Currently the data writes out without issue but the table stays as a single row, not expanding to fit the data in the table.
Similar to this community thread, and this idea.
Currently, FME's Excel writing library does not have support for tables and we cannot modify them. Excel has marked out the table’s extents in the sheet and we are simply appending to the existing range. With enough interest we could add a new library to tackle this issue.
This would be really nice to have! Currently, I'm limited to using an Excel template with macros or a Python library like openpyxl. Having this built-in support for tables would be a great addition!
All the votes have been transferred into this idea.