Skip to main content
Question

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

  • July 24, 2020
  • 1 reply
  • 153 views
D
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 Attachments
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

M
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.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.