UFT
Introduction to UFT Installation of UFT UFT GUI Recording the application Directory structure and file extension of UFT test VBScript Basic UFT concepts Object Spy Test Settings Properties Test Run Settings Environment Recovery Associating library files Object Identification mechanism Object repository Object repository Manager Associating repositories with UFT tests Launching applications Loading ini fileDifference between QFL and VBS file Automating web applications automating Windows applications Handling Databases Mathematical operations Create new Excel workbook file Read and Edit Excel workbook Delete excel workbook fileBuilt in Objects
SystemUtil Datatable CryptDotNetFactory Extern OptionalStep PathFinder MercuryTimer RandomNumber Recovery Reporter RepositoriesCollection TextUtil XmlUtil Err objectAdvanced
Description programmingRecovery ScenariosLaunching the UFT using ScriptAutomation FrameworkMisc
UFT Vs Selenium UFT Vs Appium UFT vs LeanFTLimitations and drawbacks of UFTInterview Questions and answersRead and edit excel in UFT
Here is an example that illustrates how to read and edit excel workbook in UFT.
'create new Excel application object
Set excelApp = createobject("excel.application")
'make excel application visible
excelApp.Application.Visible = true
'open an existing workbook
excelApp.Workbooks.Open "C:UsersSagarDocumentsBooksUFTmyExcelWorkBook.xls"
'get first worksheet from workbook
Set worksheet1 = excelApp.ActiveWorkBook.worksheets(1)
'get total rows in worksheet
Row=worksheet1.UsedRange.Rows.Count
'Get total columns in excel file
Col=worksheet1.UsedRange.columns.count
'Read values
For i= 1 to Row
For j=1 to Col
Msgbox "Data in cell (" & i & "," & j & ") " & worksheet1.cells(i,j).value
Next
Next
'Write some data in cells
worksheet1.cells(1,1).value ="New Paul"
worksheet1.cells(1,2).value ="New Watson"
'save workbook
excelApp.ActiveWorkbook.Save
'quit the excel app
excelApp.Application.Quit
'release the resources
Set worksheet1 = nothing
Set excelApp=nothing
Web development and Automation testing
solutions delivered!!