In the Etlworks Integrator, you can use an Excel worksheet index when reading Excel workbooks instead of a name.
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
2, etc., the Etlworks Integrator will load the worksheets named
2, etc. instead of the worksheets with the index
Please sign in to leave a comment.