Skip to main content
Solved

Skipping first row in Excel File with FeatureReader

  • March 17, 2023
  • 1 reply
  • 365 views
J
Forum|alt.badge.img

Hello, I am trying to read an excel file with FeatureReader but my excel file has an extra row before the true header row.

 

Row 1: Report Title

Row 2: Header Row

Row 3-N: Data

 

Is there a way to skip over the first row when reading in the file with FeatureReader?

 

Thank you

Best answer by david_r

You can specify the cell range in the reader parameters, e.g. with headers (field names) on row 2 and data starting on row 3:

image

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

david_r
Celebrity
  • david_rCelebrity
  • 8391 replies
  • Best Answer
  • March 17, 2023

You can specify the cell range in the reader parameters, e.g. with headers (field names) on row 2 and data starting on row 3:

image

Community Stats

32,065
Posts
121,732
Replies
39,691
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.