Question

Why does schema reader complain of named range when there are none?

  • 24 July 2020
  • 1 reply
  • 28 views

Badge +1

2020-07-24 14:29:55| 0.4| 0.0|WARN |Excel Reader: Internal error: Could not find any sheets to read

2020-07-24 14:29:55| 0.4| 0.0|WARN |Excel Reader: Found named range '_xlnm__FilterDatabase' on sheet 'Haul Data'. This is a Microsoft Excel internal name so FME will not show it as a sheet. If you wish to read this named range, please rename it

 


1 reply

Badge +2

@deanrother What version of FME are you using? I couldn't reproduce the WARN you're seeing in FME 2018 -> 2020.1 . would you be able to attach a sample workspace that reproduced the error?

 

As far as I can tell, these are internal, hidden tables that Excel creates. People working in VB.NET etc. seem to encounter them. I couldn't find a way to clean them up.

Reply