+10I have several Excel writers in a workspace and one throws the warning below. I checked the parameters and they are all the same. Does anyone know where this can be changed? Thanks!
Excel Writer: Invalid value '<Unused>' supplied for parameter 'xlsx_field_names_formatting'. Reverting to default value 'yes'
Best answer by kailinatsafe
Hello @sigbono, I think this attribute corresponds with the following parameter on the Excel Writer:
To understand what this parameter is used for, consider checking out the documentation: Format Field Names Row parameter. At a quick glance, it looks like this parameter controls field header formatting. May I ask what version of FME Workbench you're using? and when you encoutner this error?
If you do not wish the apply formatting to header fields, try leaving this value as default! Happy to help, Kailin
+21Hello @sigbono, I think this attribute corresponds with the following parameter on the Excel Writer:
To understand what this parameter is used for, consider checking out the documentation: Format Field Names Row parameter. At a quick glance, it looks like this parameter controls field header formatting. May I ask what version of FME Workbench you're using? and when you encoutner this error?
If you do not wish the apply formatting to header fields, try leaving this value as default! Happy to help, Kailin
+10Hello @sigbono, I think this attribute corresponds with the following parameter on the Excel Writer:
To understand what this parameter is used for, consider checking out the documentation: Format Field Names Row parameter. At a quick glance, it looks like this parameter controls field header formatting. May I ask what version of FME Workbench you're using? and when you encoutner this error?
If you do not wish the apply formatting to header fields, try leaving this value as default! Happy to help, Kailin
Hi @kailinatsafe , thanks for the reply. I am using FME 2021.2, and this happens in a workspace that converts geodatabase features to Excel files. In these writers, I am using a Template File and Sheet which has formatted headers. Might that be the cause of the warning? The files are written to Excel correctly though, it just shows these warnings in the translation log.
+21Hi @kailinatsafe , thanks for the reply. I am using FME 2021.2, and this happens in a workspace that converts geodatabase features to Excel files. In these writers, I am using a Template File and Sheet which has formatted headers. Might that be the cause of the warning? The files are written to Excel correctly though, it just shows these warnings in the translation log.
Hello @sigbono, thanks for explaining! If you're seeing expected results, I think its safe to ignore the warning in the logfile. Moving forward, most warnings can often be ignored. Typically, if you're seeing unexpected results or behaviour, we can use warnings to get an idea of where FME is going wrong or struggling. Hope this helps! Kailin.
+3Hi @kailinatsafe, when you choose “No” for parameter “Output Field Names”, then “Format Field Names Row” is greyed out with no value. Therefore I still get this warning on each run.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
