+8Hello,
For the logged known issue in FME Form “FMEENGINE-82549” with “Excel Writer: Field Names row not written” the solution described is to Set the Row Height to 0 on the Feature Type, as discussed here. But what are the steps to do that? Is it to simply just use transformer “ExcelStyler” and use setttings for “apply style to”?
Thanks!
Best answer by kailinatsafe
Hello
This parameter can be found in the Excel Writer Feature Type. If you double click the writer feature type and expand the “Field Names Row Formatting” section under “Sheet Settings”, there is a “Row Height” parameter we can set to “0”.
Let me know if you are still having issues setting row height. On a more positive note, I think the fix can be found in the latest FME Form 2024.2 beta available on Downloads. Happy to help, Kailin.
+23Hello
This parameter can be found in the Excel Writer Feature Type. If you double click the writer feature type and expand the “Field Names Row Formatting” section under “Sheet Settings”, there is a “Row Height” parameter we can set to “0”.
Let me know if you are still having issues setting row height. On a more positive note, I think the fix can be found in the latest FME Form 2024.2 beta available on Downloads. Happy to help, Kailin.
+8Hello
Btw, would it be possible if not already implemented, to request the option to freeze first row in excel? which is manually done by going the “View/ Freeze panes/ Freeze top row.
+8Actually now I saw that there is indeed an option for “Freeze first row” in the parameter settings 😀
+23Hello
