Solved
No Header Values when Reading in Excel Doc
I am trying to read in an excel document and the frist row contains my column names. After reading in the document all I see in FME is Column 1, Column 2 and so on. I am not sure what I am doing wrong, other than when I use the Microsoft Excel ADO (deprecated) format the headers appear in FME, and when I use the newer excel format the headers do not appear in FME. I would appreciate any healp with this.
Best answer by fmelizard
Hi Matt,
The new xls reader has a column that defines the headers you just need to input 1 if the header is the first row, see field names row
Itay
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.
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.
+22- Safer
- Best Answer
Hi Matt,
The new xls reader has a column that defines the headers you just need to input 1 if the header is the first row, see field names row
Itay
Itay,
Thanks for the quick response! That worked great, now if I could get my module to work and actually output data I would be completely satisfied. Again, thanks for the answer, I really appreciate it!
Matt
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.