Hi Swapnadeep,

Try this

DataTable.AddSheet "MySheet"
DataTable.ImportSheet "C:\temp\test.xls",sourceindex,"MySheet"

' You can also delete the other sheets if you do not want them
DataTable.DeleteSheet "Global"
DataTable.DeleteSheet "Action1"


With Regards,
Johnson Solomon

-- 
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en

Reply via email to