UFT
Introduction to UFT Installation of UFT UFT GUI Recording the application Directory structure and file extension of UFT test 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 Description programming SystemUtil Datatable CryptDotNetFactory Extern OptionalStep PathFinder MercuryTimer RandomNumber Recovery Reporter RepositoriesCollection TextUtil XmlUtil Launching applications Loading ini fileDifference between QFL and VBS file Automating web applications automating Windows applications Err object Recovery Scenarios Handling Databases Mathematical operations Create new Excel workbook file Read and Edit Excel workbook Delete excel workbook file Launching the UFT using Script UFT Vs Selenium UFT Vs Appium UFT vs LeanFT Limitations and drawbacks of UFTCreate new excel workbook in UFT
Here is the example that illustrates how to create new excel workbook in UFT.
'create new application object
Set excelApp = createobject("excel.application")
'make excel application visible
excelApp.Application.Visible = true
'Create new workbook
excelApp.Workbooks.Add
'get first worksheet from workbook
Set worksheet1 = excelApp.ActiveWorkBook.worksheets(1)
'Write some data in cells
worksheet1.cells(1,1).value ="Paul"
worksheet1.cells(1,2).value ="Watson"
'save workbook
excelApp.ActiveWorkbook.SaveAs "C:UsersSagarDocumentsBooksUFTmyExcelWorkBook.xls"
'quit the excel app
excelApp.Application.Quit
'release the resources
Set worksheet1 = nothing
Set e
Complex problems, Simple Solutions