Hello Andrew.
Could you please show us what error is being returned?
Here we use DDT with ADO Objects, but I have used Excel either. All I can do to help is show how we worked with sheets:
function login()
{
try {
Log.Message("Load the sheet");
sheet = DDT.ExcelDriver("C:\\Importa_Tabelas\\BeWeb.xlsx", "Login", true);
} catch (exception) {
Log.Error("Something wrong hapenned - " + exception.description + ". Check the sheet's path.");
Runner.Stop();
}
Log.Message("Select the string connection");
CboConn.ClickItem(sheet.Value(0));
Sys.Browser().Page("*").Wait();
Log.Message("Set the login");
TxtLogin.SetText(sheet.Value(1));
Log.Message("Set the password");
TxtPassword.SetText(sheet.Value(2));
Log.Message("Click enter");
BtnLogin.ClickButton();
Sys.Browser().Page("*").Wait();
}
