Interested to Buy Any Domain ? << Click Here >> for more details...
I want to import the sheet from the Excel to the Datatable
using VB Script. I used the Syntax
as 'Datatable.ImportSheet "Filename","SourceSheet","Destinat
ionSheet"
Ex:
Datatable.ImportSheet "D:\Data1.xls","Sheet1","Global"
Qtp producing run time error,How I can solve the problem
- 1 Answers
- 3427 Views
- I also Faced
- E-Mail Answers
Answer Posted / swayam.nayak
Instead of writing Datatable.ImportSheet "D:Data1.xls","Sheet1","Global" this
Try to put this code
"D:Data1.xls","Sheet1","1"
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi Friends Rajendra this is bhavani prasad, iam working Hyderabad. i faced one problem with qtp recording mode i.e in my application there is 100 records first we click the first record that record will be jumped to next session and 99 records will there stop the recording and run the same script .Run this script qtp does not identify the records. So plz tell me what is the solution.
Mention when to use function procedures and what are its characteristics?
What are the environments supported by vbscript language?
Which object provide information about a single runtime error in a vbscript?
How to assign a numeric value to a variable?
What are class properties?
How to take whole text output from screen of Bitmap Application.
What are the special sub-types in vbscript?
Hai this is sheik, i want to learn VB scripts for web application pls guide me what are all basic things need to know to learn VB scripts in web application.
Explain the arrays in vb script?
What are class events?
How to throw an error in vbscript?
How to make sure that items in a wintree are sorted al?
How can the spaces from the string be removed?
How to delete a cookie using vbscript?
