In the Etlworks Integrator, you can read an Excel worksheet with a header, not in the first line.
To read the Excel worksheet from the specific line (and in some cases to the specific line) when creating an XLS or XSLX Format, enter the number of the row where the header starts in the
Start row field. Optionally, enter the number of the last row to read in the
End row field.
Please sign in to leave a comment.