private static void OpenExcelAndLogin()
 {
     UIMap.ClearRegistryApiKey();
     UIMap.OpenExcelAndWorksheet();
     UIMap.OpenLoginPage();
     UIMap.LoginWithApiKey();
 }
        public static List <object> PrepareTest()
        {
            var returnList = new List <object>();

            Playback.PlaybackSettings.DelayBetweenActions = 10;
            UIMap.ClearRegistryApiKey();
            var excelApp = new ExcelApp.Application();

            excelApp.Workbooks.Add();
            excelApp.Visible = true;
            string path    = Path.Combine(@"C:\Users\", Environment.UserName, @"AppData\Roaming\Quandl\Quandl.Excel.UDF.Functions-AddIn.xll");
            var    myAddin = excelApp.AddIns.Add(path);

            myAddin.Installed = true;
            returnList.Add(excelApp);
            returnList.Add(excelApp.ActiveSheet);
            return(returnList);
        }
 public static void CompleteCodedUITest()
 {
     UIMap.ClearRegistryApiKey();
 }