Hello @epro_admin, thanks for posting and sorry for not reaching out sooner! I believe the only way to control cell height using FME is with a template file. I was optomistic, but I came across a snippet in the following article (that discusses writing images to excel):
"(6) Add the Excel Writer: In the Writer Parameter dialog set Overwrite Existing File = Yes. Set the template file to be FireHallsTemplate.xlsx. We use a template file that has the row heights preset. Otherwise the images will overlap."
Unless you're able to use the formatting options on Excel Writer > User Attributes > Formatting > Edit... > Text Control, exploring the template option could be a good alternative:
Further, I haven't seen any FME Ideas for controlling cell height in FME. If this is functionality you would like to see added to FME in the future, please consider creating an idea. If you create an FME Idea, feel free to link it for other users to find! Happy to help, Kailin.
Hello @epro_admin, thanks for posting and sorry for not reaching out sooner! I believe the only way to control cell height using FME is with a template file. I was optomistic, but I came across a snippet in the following article (that discusses writing images to excel):
"(6) Add the Excel Writer: In the Writer Parameter dialog set Overwrite Existing File = Yes. Set the template file to be FireHallsTemplate.xlsx. We use a template file that has the row heights preset. Otherwise the images will overlap."
Unless you're able to use the formatting options on Excel Writer > User Attributes > Formatting > Edit... > Text Control, exploring the template option could be a good alternative:
Further, I haven't seen any FME Ideas for controlling cell height in FME. If this is functionality you would like to see added to FME in the future, please consider creating an idea. If you create an FME Idea, feel free to link it for other users to find! Happy to help, Kailin.
One idea would be to have a VBA macro within the Excel template so that it will run on open when the Excel file is written. Here is a link to one that might be of use.
Automatically autofit row heights for columns where the text wraps when loading an Excel sheet? - Microsoft Q&A
@kailinatsafe and @Chris Warren - thank you both for your replies. I am neither an FME or VBA macro expert, but I will give these a try anyway! If anyone else has any other ideas keen to hear. Thanks again for your time.
