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.
Archived
I'd like FME to support writing data to Excel Tables (Issue # FMEENGINE-37822)
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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.
+13- Safer
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.
+14- Contributor
But if we do not know ,how many rows or columns will be in the output bcs it depends on the input file,may be the input
changes.so i think,we should do sth.relates to count rows and column to generate Excel Table output as we required
+21- Safer
Updated idea statusGathering Interest→Archived
Idea merged into:All the votes from this idea have been transferred.