SchemaMapper column name issue

Question

Good morning,

In the Excel document SchemaMapper.xlsx the name of this column is "_UNFeatureClass", but when I run the FME workbench it returns this warning. It looks like it does not refresh the column name.

Is there a way to force FME to refresh the SchemaMapper Transformer (SchemaMapper_18)?

Log file Message: "SchemaMapper_18  Transformer
Excel Reader: Sheet 'Assettypes' of dataset 'C:\Workspace\UtilityNetwork_Migration\SchemaMapper.xlsx' has column '_UNFeatureClass' that does not match a header column in the file. This column will not be read."

Thanks

SanchezNuñez · Answer

Esri assisted us with this issue. It appears that when using ArcGIS Pro 3.5.x together with FME, the libxl.dll file from ArcGIS Pro needs to be replaced with the libxl.dll file from FME.

To resolve this, we copied the libxl.dll file from:

C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\plugins

to:

C:\Program Files\ArcGIS\Pro\bin

After making this change, everything worked as expected.

This is a known issue: FMEENGINE-87239.

Hope this helps.