Skip to main content
Question

Reading Order of Multiple Excel Sheets

takashi
Influencer

Hello,

 

I have an Excel dataset containing many sheets (feature types), and have to read them in the original order - from left to right shown in the Excel user interface. e.g. Sheet2 -> Sheet4 -> Sheet3 -> Sheet1 in the case shown in this screenshot.

As long as I tested so far, FME seems to read the worksheets (feature types) in my desired order, but I'm not sure if it's guaranteed as the implementation of the Excel reader.

Could you please confirm that it's guaranteed not only in the current and also in the future?

3 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • Contributor
  • November 4, 2019

Hi Takashi,

As far as I know, only the order of readers is guaranteed.

So, if you want to be sure, use multiple readers (one per sheet).

I know, not best practice, but the order of reading will be the order of the readers listed in the Navigator window.

M
Forum|alt.badge.img+2
  • markatsafe
  • November 8, 2019

@takashi Please add you voice to this Idea

takashi
Influencer
  • takashiInfluencer
  • Author
  • November 9, 2019
markatsafe wrote:

@takashi Please add you voice to this Idea

Yes, that's a great idea, but is not the case for this question.

Reply


Helpful Members This Week

Community Stats

31,319
Posts
118,817
Replies
38,946
Members

Latest FME

Terms & ConditionsCookie settings

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