Skip to main content
Question

How to update field in XLSX files

  • April 5, 2023
  • 1 reply
  • 82 views

hugues
Contributor
Forum|alt.badge.img+2

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

daveatsafe
Safer
Forum|alt.badge.img+19
  • Safer
  • April 5, 2023

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings