UFTIntroduction 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 file
Built in ObjectsSystemUtil Datatable CryptDotNetFactory Extern OptionalStep PathFinder MercuryTimer RandomNumber Recovery Reporter RepositoriesCollection TextUtil XmlUtil Err object
AdvancedDescription programmingRecovery ScenariosLaunching the UFT using ScriptAutomation Framework
MiscUFT Vs Selenium UFT Vs Appium UFT vs LeanFTLimitations and drawbacks of UFTInterview Questions and answers
Create new excel workbook in UFTHere 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