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 answersDatatable object in UFT
Datatable object is used to store the test data required for testing the application. You can think of DataTable as a Excel Workbook. By default, excel file (default.xls) from the test directory is imported when the test run is started. Just like Excel workbook, a datatable can have one or more sheets in it. There is a special sheet in Datatable called as global sheet. Any action within a test can access data from global sheet. For each row in the global sheet, test is repeated for that row. But we can change this iteration setting from test settings dialog. Other than global sheet, we also have sheet per action and only specific action can access data from such sheet. We can also add extra sheet in a data table. The changes you make to the datatable are not saved parmanently. To save the changes in the datatable, you will have to export your datatable to excel file. We can perform various operations on Datatable and Datasheet as mentioned below.- Access data from global and local sheet
- Write data to global and local sheet
- Iterate through the rows and columns of the sheet
- Import all or specific sheets from the excel workbook in Datatable
- Export all or specific sheet from Datatable to excel file
'to import all sheets from excel file, use below line of code
datatable.Import "mydata.xlsx"
'To add new sheet in datatable, use below line of code
datatable.AddSheet "uftsheet"
'to import single sheet from excel file, use below line of code
'here we are importing the sheet data from mydata.xls into uftsheet in datatable.
datatable.ImportSheet "mydata.xlsx","data","uftsheet"
'You can add a parameter using below syntax. Second argument is the value of the parameter
'Here we have added parameter with name - result
datatable.GetSheet("uftsheet").AddParameter "result", "paramValue"
'to read value from cell, use parameter name and sheet name
msgbox datatable.Value ("result","uftsheet")
for i=1 to 2
msgbox datatable("result","uftsheet")
'to move to next row, use SetNextRow method
datatable.GetSheet("uftsheet").SetNextRow
next
'Below code gets the total used rows in the sheet
datatable.GetSheet("uftsheet").getRowCount
'Below code set the pointer to first row in uftsheet
datatable.GetSheet("uftsheet").setCurrentRow(1)
'To Export complete datatable, use below line of code
datatable.Export("exp.xlsx")
'export only particular sheet from the datatable to excel file, use below line of code
datatable.ExportSheet "specificsheetexport.xls","uftsheet"
'Check if parameter exists in sheet.
on error resume next
val=DataTable("result","uftsheet")
if err.number<> 0 then
msgbox ("Parameter result does not exist in uftsheet")
else
msgbox "Parameter result exists in uftsheet"
end if
Web development and Automation testing
solutions delivered!!