Question

How to update field in XLSX files

  • 5 April 2023
  • 1 reply
  • 2 views

Hi. I"ve a XLSX files. The XLSX files contain 2 sheets. Each sheets have common field (sample_ID). The first sheet is a description of the sampler, like the report name. In the second sheet it's the result of station. For each station it'S have many result ( 1 to M relation). I want to update a field in the second sheets with the value of the first sheet. But i have a error message (check the Capture files). Thank for help :)


1 reply

Userlevel 2
Badge +17

Hi @hugues​,

In the Parameters for the output feature type, please set Use Attribute Names as Column Positions to 'No'. This is currently set to Yes, leading the writer to expect the attributes to have allowable Excel column names (ie. F, AA, BD, etc.). Changing to No will cause to writer to use the first row values as the column names.

Reply