Skip to main content
Question

Is there a way to read Excel attributes(columns) dynamically?

  • March 28, 2022
  • 1 reply
  • 133 views

robotix
Contributor
Forum|alt.badge.img+10

I have read multiple questions\\answers\\commentaries around this topic and I may be more confused than before.

Here is the scenario:

  1. I have an excel workbook
  2. The sheet names are always the same
  3. Some of the columns are static
  4. Some of the column names change-- and sometimes there are more or less columns
  5. I need to capture the column names and row values then process the info
  6. The only way I have seen to update columns is to manually refresh the reader with 'Update Feature Types'
  7. Is there a way to dynamically read in new or changed excel column names without manual intervention? FME 2021.2

Thanks!

1 reply

verdoodtdries
Supporter
Forum|alt.badge.img+18

With a Schema reader, you can read the (new) attributes of your altered Excel-file. This schema can be the start point of your workflow to process the Excel columns of interest.Schemareader


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