+1
I need to be able to set the row for the field names to Row 3 for a folder of excel files.
The only way to do this I have found is to read each excel and set the row to 3 in the Parameters dialog.
This is very time consuming and I am guessing there is a way to set Row 3 for all Excel files read in from a folder.
Any ideas welcome.
Would a dynamic reader help you? That way you'd only have to specify this once.
+6
As @david_r said, you can use the dynamic reader.
But you need to set Additional File Handling to "Apply current settings to additional files". Because the default setting is "Apply default setting to additional files".
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
