Blog to understand automation concepts in QTP, Selenium Webdriver and Manual Testing concepts
To view or not the test results in UFT
Once a test is executed in QTP/UFT, test results are displayed. UFT provides us the option to view the test results once the test execution completes. Follow following steps for the same.
Selenium WebDriver Automation concepts: Log file for Selenium IDE execution using FileLogg...
Selenium WebDriver Automation concepts: Log file for Selenium IDE execution using FileLogg...: We can create log files of selenium IDE test execution and store in an file using the below process: 1. Download the File Logging add...
Selenium WebDriver Automation concepts: Selenium Commands in Selenium IDE
Labels:
Selenium Automation,
Selenium WebDriver
Selenium WebDriver Automation concepts: Selenium Commands in Selenium IDE: Components of teststep in Selenium IDE A test step in Selenium comprises of following: Selenese Commands - set of selenium commands...
Selenium WebDriver Automation concepts: Exporting selenium IDE tests to WebDriver
Sorting excel data multiple times based on column Name using VBScript
Labels:
Advanced QTP,
QTP,
VBScript,
VBScript Tutorials
''Input Information - Workbook file Name with path ''WorkSheet Name '' Provide the sort criteria based on which data needs to be filtered seperated by | WorkBookFile = "C:\\testing.xls" SheetName = "testing" MultipleSortCriteria = "TestName|TestClass|TestPath" '' Define the constants to be used in the script Const xlYes = 1 Const xlAscending = 1 Const xlDescending = 2 Set oXL = CreateObject("Excel.Application") Set oWB = oXL.WorkBooks.Open(WorkBookFile) Set oWS = oWB.Worksheets(SheetName) Set oRnge = oWS.UsedRange ColCnt = oRnge.columns.count '' Create an array based on the sort criteria provided aSrtCriteria = split(MultipleSortCriteria,"|") For i = ubound(aSrtCriteria) to 0 step -1 ''Loop the times data needs to be sorted For j = 1 to ColCount step 1 If (oWS.cells(1,j).value =aSrtCriteria(i)) Then '' Sort the data based on the column name Set oRngeSrt = oXL.Range(Chr(asc("A")- 1+j) & "1") oRnge.Sort oRngeSrt, xlDescending, , , , , , xlYes oWB.save Exit For End If Next Next oWB.Close oXL.Quit Set oWB = Nothing Set oXL = Nothing
Subscribe to:
Posts (Atom)