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.
<strong>This post is closed to further activity.</strong><br />
It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br />
If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br />
If there is a genuine update to be made, please contact us and request that the post is reopened.
+11- 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.
+13- 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
+15- Safer
Updated idea statusGathering Interest→Archived
Idea merged into:
All the votes from this idea have been transferred.
1 person upvoted this
+15- Safer
Idea merged into:
All the votes from this idea have been transferred.
All the votes from this idea have been transferred.
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.