In Etlworks the name or index of the Excel worksheet is configured in the Excel format.
If you want to use the same connection and format to read from or write into different Excel worksheets, when creating the source-to-destination transformation use the
filename|worksheet notation in the FROM or TO. Example:
matrix.xlsx|income tells the system to read data from the worksheet
income in the file