Friday 4 October 2013

How to read a value from the cell in datatable sheet in QTP?

Reading a value from the cell in a sheet from datatable is a 2 step process.

  1. In first step we set the row pointer
  2. In second step we specify the parameter/column name from the sheet to read

Example ->

'In Below example, we have set the row pointer to 2 in transaction sheet
datatable.GetSheet("Transactions").SetCurrentRow(2)

'in below code we have specified that we want to read a value from the Module_Name column from the 'transactions sheet
print datatable.Value ("Module_Name","Transactions")

This is how we can read values from the datatable in QTP.

You may find below links very useful if you want to know more about data tables in QTP.

  1. How to export datatable sheets to excel
  2. How to import excel-sheet to datatable
  3. How to read value from cell in datatable in QTP
  4. Explain setcurrentrow method in qtp
  5. Datatable object in qtp
  6. How to export datatable to excel in qtp
  7. How to get current sheet from datatable
  8. How to check if parameter exists in sheet in datatable in qtp
  9. Explain dtsheet object in qtp
  10. What are the utility objects in qtp


Please give your inputs, suggestions, feedback to Us about above QTP topic. We value your thoughts.

No comments:

Post a Comment

Please Leave your reply. We value your feedback and inputs

Best QTP Books

Everything About QTP

Hello Friends,
You can find QTP study material, Multiple choice questions (mcq), QTP question bank, QTP question papers, QTP notes, QTP questionnaire, scenario based QTP interview questions, QTP tutorial and QTP training on this site.

If you are a fresher or experienced QTP professional with (1/2/3/4) years of experience, this blog is just for you.