Is there any way to read dynamically any excel file and that the header are simply the column name A, B, C, D...
Through a Reader I can read any Excel file but the problem is that it always takes the first row as the header.
Thank you!
+51- Celebrity
When you add your reader, click ‘parameters...’
then set ‘Field Names Row’ to ‘0’
+8- Contributor
Hi
However, as I explained, I need to read dinamically any Excel file so I can't select a sheet in the parameters view and set ‘Field Names Row’ to ‘0’.
I manage to read any file and get the features through the generic port. However, FME always interprets the first row as header and this is what I don't want.
The way I do this is to use the Generic Reader. This results in columns like col0, col1, col2, etc...
1 person upvoted this
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.