My system is getting struck when i import excel sheet to the QTP runtime DataTable

[Saket]

Hi Mani,

Thanks for such a detailed post, it helps to understand the exact issue. If you want to import an Excel file in your Datatable.
Just do the two steps
1. Add a sheet to your datatable
2. Import the sheet you want from the excel file

Try this

Code:

Datatable.AddSheet "Sheet1"
Datatable.ImportSheet C:\Testcases.xls",1,3

In your mentioned steps I can see you have imported the excel in line 3
if you do a Import, the imported xls replaces all data in the existing run-time Data Table (including all data sheets).
also the files mentioned are different, I beleive you need to use the file mentioned earlier.

Hope this helps, let me know there is any issue.

---

Sorry, I misunderstood, I beleive you are preparing the datatable by importing the sheet.
just noticed that you have taken a blank test.

this is working fine when I tried. I doubt there must be some issue the DataTable.xls.