After importing external .xls datasheet in to Datatable of QTP, How to set NO of iterations run for all row in the Datatable? I mean We dot know How many rows are existed before importing the .xls sheet

  • Interview Candidate
  • 4
  • 2015

Showing Answers 1 - 4 of 4 Answers

AM

  • Jun 8th, 2006
 

FOR i = 1 to datatable.getsheet("sheetname").getrowcount.getrowcount command will read up to the last record

  Was this answer useful?  Yes

yasvanth

  • Jun 8th, 2006
 

FOR I=1 TO DATATABLE.GETSHEET("SHEET NAME").GETROWCOUNT

  Was this answer useful?  Yes

Yogi

  • Aug 30th, 2006
 

hi,

Just right click on actionIn keyword viewafter the .xls. then select action Call properties, a dilouge box will open ,there u can select One iteration ,all rows or specifying the row nos.

ok

Enjoy!!

Yogi

  Was this answer useful?  Yes

Adil Anees

  • Oct 22nd, 2006
 

Hi

I use external xls file to import the data into local sheet.It gets Imported sub sequently.

When you say run from "AllRows" or "Run from 1- 5" It holds only the first row.

and runs only the first iteration (which is btdefault) and hence the execution stops.

Can anyone help me and send your replies to syeda@bupa.com

Thanks,

Adil.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions