@Ankur: Thanks for looking into this! As the excel expert confirms, there may not be an easy fix for this.
Can I pick your brains on my proposed solutions then:
Option 1) Rename all tests greater than 14 chars (as well as the scripts where they are called) to names less than 14 chars. This will ensure that dtLocalSheet reference does not exceed 31 chars at any given time. This may also involve copying data from the old (long-named) sheets into new (shorter-named) sheets
Option 2) For tests with names greater than 14 chars, make use of named sheets in the excel workbook (eg. DataTable("DataEntry_CreditCardPaymentDetails","Payment") instead of dtLocalSheet. Modify the tests to replace dtLocalSheet with the respective assigned sheet ("Payment") for each of the tests.
Unless I'm missing something, I'm thinking Option 2 is the better bet. My motive is to make minimal changes to the code. I think I'd be better off making changes to spreadsheet names rather than the names of the tests themselves.
What do you think?
Can I pick your brains on my proposed solutions then:
Option 1) Rename all tests greater than 14 chars (as well as the scripts where they are called) to names less than 14 chars. This will ensure that dtLocalSheet reference does not exceed 31 chars at any given time. This may also involve copying data from the old (long-named) sheets into new (shorter-named) sheets
Option 2) For tests with names greater than 14 chars, make use of named sheets in the excel workbook (eg. DataTable("DataEntry_CreditCardPaymentDetails","Payment") instead of dtLocalSheet. Modify the tests to replace dtLocalSheet with the respective assigned sheet ("Payment") for each of the tests.
Unless I'm missing something, I'm thinking Option 2 is the better bet. My motive is to make minimal changes to the code. I think I'd be better off making changes to spreadsheet names rather than the names of the tests themselves.
What do you think?