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,
View original
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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.
+17- Contributor
- 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
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.