Skip to main content
Question

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

  • July 24, 2020
  • 1 reply
  • 122 views

Forum|alt.badge.img+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

Forum|alt.badge.img+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.

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