I just follow this tutorial (https://knowledge.safe.com/articles/34364/using-a-template-file-when-writing-excel-data.html) try to write data to Excel table and found looks difficult, see attached image, write to Named Range in Excel looks perfect. Thank you.
I'd like FME to support writing data to Excel Tables (Issue # FMEENGINE-37822)
FME Form
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
A bit more information about Excel Tables:
A table is a special structure in an Excel document. It has filter cells on the headings and special formatting for the cells. In excel, you can specify a table and then as you add data to it, the formatting expands to each column or row added. See here for an example: http://www.excel-easy.com/data-analysis/tables.html
You can create a template excel file with a table but you have explicitly know the Rows/Columns that you need or the formatting will not be applied to all the data.
changes.so i think,we should do sth.relates to count rows and column to generate Excel Table output as we required
All the votes from this idea have been transferred.