Description

After associating the Excel file with the script, I see the below error when clicking into the Mapper.

Applies to

Transaction 10.x

Cause

There is an issue with Winshuttle 10.x and Office 365/Spreadsheet gear. This is resolved in v11.4.1 and higher.

Solution

Check the format of your Excel file. If the format is ".xlsx" please try changing this to ".xls" resave and try again.

If this is a not a feasible option. Please try the following:

1. Within software open Application Defaults

2. Uncheck the "Use Excel Spreadsheet in Mapper Preview"

If Preview if still needed

1. Close all instances of Excel and Transaction
2. Go to AppOptions.xml
3. Search for ExcelviaSpreadsheet Tag
4. Change value to False

Then re-run the scenario.

Additional Information

Issue has been resolved in version 11.x and higher of Studio