I would like to share the solution. I got solution from friend Raghu. It worked excellently.
Follow the steps to Import Datasheet from QC to QTP
1. First Go to Tools->options->Folders and add the path in the search list.
2. To Import the sheet from Quality Center, type following
StrPath=pathfinder.Locate("Test.xls")(Where Test.xls is the file name located in QC)
datatable.ImportSheet StrPath,FolderName,"Global" .(Where FolderName is the Sheet Name)
3. Run the script and check the contents in the Runtime datatable of Test results
I hope this answers your question.
Do let me know if you need more info.
Pathfinder is a good option for this problem however can Pathfinder be used recursively??
Suppose I have Folder "D:\folder1" in Tools->Options->Folder" tab and my file is present in "D:\folder1\Folder2" then I guess pathfinder does not work?? can we do something which will find the file path recursively?