A new option to automatically set the cell width for the Excel Writer.
Released
Excel Writer-Automatic cell width
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.
+2It would be nice to have a checkbox to set the column width to automatically resize according to the cell contents. Please launch for Excel Writer and Feature Writer (xls)!
+11- Contributor
I believe that setting '0' for the column width at the excel writer will achieve this.
+15- Safer
Correct! This is currently in FME 2021.0 betas. In the Excel writer feature type, if you set the display width value to 0, this will set the column width to automatically resize.
Try it out here: www.safe.com/beta
+11- Contributor
Hi @andrea, On the webinar 'Ask Me Anything About Excel Integration' of 'February 3rd, 2021' (https://www.safe.com/webinars/ask-me-anything-about-excel-integration/), it was mentioned that this was actually already implemented in FME 2020. If I try it out on FME 2020.1.1.1, it already works for me, so I would think it is actually already (silently) released instead of In Beta.