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 answersCreate 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
Web development and Automation testing
solutions delivered!!