Solved

Where can I change this 'xlsx_field_names_formatting' parameter in an Excel writer?

  • 21 March 2023
  • 4 replies
  • 49 views

Badge +7

I 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'

 

icon

Best answer by kailinatsafe 24 March 2023, 17:07

View original

4 replies

Userlevel 3
Badge +15

Hello @sigbono​, I think this attribute corresponds with the following parameter on the Excel Writer:

 

image 

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

Badge +7

Hello @sigbono​, I think this attribute corresponds with the following parameter on the Excel Writer:

 

image 

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.

Userlevel 3
Badge +15

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.

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.

Badge +2

Hi @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.

Reply