public void CreateCustomerData(ref ISelenium browser) { try { var admincommonObj = new AdminSuite.Common(); string user, password = "******"; _testDataFilePath = _currentDirPath.Parent.FullName; _app = new Application(); //var testDataObj = new TestData(); _app.DisplayAlerts = false; _workBook = _app.Workbooks.Open(_testDataFilePath + "\\TestData\\TestData.xls", 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false); _workSheets = _workBook.Worksheets; var _userSheet = (Microsoft.Office.Interop.Excel.Worksheet)_workSheets.get_Item("Users"); Random rnd = new Random(); int rndNumber; for (int i = 0; i < 10; i++) { rndNumber = rnd.Next(10000); user = "******" + rndNumber; admincommonObj.CreateCustomer(browser, user, password); _userSheet.Cells[i + 2, "B"] = user; _userSheet.Cells[i +2, "C"] = password; admincommonObj.PerformManualAdjustment(browser, user, "Test Accounts", "100", "Yes", "Test Accounts", "", "", "", "Today"); _workBook.Save(); } } catch (Exception Ex) { Framework.BaseTest.CaptureScreenshot(browser, ""); Console.WriteLine(Ex.StackTrace); Framework.BaseTest.Fail(Ex.Message); } finally { _workBook.Save(); _workBook.Close(); _workSheet = null; _workBook = null; _app.Quit(); } }