Question

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

  • 28 March 2022
  • 1 reply
  • 19 views

Badge +4

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

Badge +3

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

Reply