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
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
what types of bugs will we find out in banking projects for automation testing?
how to acces the remote mechine using vb cript(QTP)
Explain about operator precedence in vb script?
How to get the length of the string by making use of the string function?
how to write codings in QTP using vb script. please help me. i am new to QTP. it is easy or very much tough. please tell me
Why is it recommended to close the database connection every time after the work is completed?
What are the different types of operators and their order of precedence?
How to access array data?
How are values assigned to string type and numeric type variables?
What is the use of option explicit statement?
write a program to display configuration of a local system with the help of vb script.
Which conditional statement is the most convenient one to use in the case of multiple conditions in the vbscript language?
Explain about arrays in vb script?
What are the environments supported by vbscript language?
Can any one provide code for Mid(string,start[,length]). I have been asked to write code for Mid(). i.e We need to define our own function say MyMid() which should behave same like built-in Mid function