How to pass data from external file (.xls) from particular sheet at run time

[Priya.Shah134]

I am using QTP 9.0 version for the automation. I have a below query :

I am passing the data from the external .xls file and the file has several sheets. In this case is it possible to instruct QTP to take the Data from the particular sheet at the run time ?

Thanks,
Priya

[Saket]

Yes, it will depend on how you are using the external xls in you script. if you do a import, try 'Datatable.ImportSheet'