Automation export task fails with below error:
Getting an error during testing ..... File-2 - "" is an unexpected token. The expected token is ';' Line 27, position 30. failed.
Export Excel worksheet name contains "&" character.
WORKAROUND:
1. In Automation window, select Export task.
2. Under Activity Input tab, next to Export XLSX file name, click on the "..." button to open Export wizard.
3. For Worksheet Name field, remove "&" character and hit OK
STATUS:
Waiting for fix to be released in a future version of Toad for Data Point.
