Overview
In Etlworks, you can use an Excel worksheet index when reading Excel workbooks instead of a name.
Process
When creating an XLS or XLSX Format, enter the 1-based index of the worksheet: 1 for the first worksheet, 2 for the second, etc.
if there is a worksheet actually named 1
, 2
, etc., Etlworks will load the worksheets named 1
, 2
, etc. instead of the worksheets with the index 1
, 2
, etc.
Comments
0 comments
Please sign in to leave a comment.