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
Which respective symbols are used to separate a line and to break the lengthy statement into multiple statements in the vbscript language?
Mention what is vbscript procedures?
What aspects of vbscript make it safe so that a web page using vbscript cannot destroy or corrupt information on a user's computer?
give me any information abou vb script books learn quckly
What are the differences between sub procedures and function procedures?
What are class variables?
What is the use of the recordset object and which statement is used to create such an object?
hi what is called GUI in QTP 8.2 and how can we test the apllication using GUI?
What are the rules to name variable in vbscript?
How will you check that a variable is an array in vbscript?
What are the 2 ways to pass a value to the function?
How can you fetch the value of a cookie?
Hi Friends my Question is very simple,in Manual testing when we click on a hyper link it directs us to the relavent page or it re-directs us to the current page,so there we can easily write testcase but same thing if we do in automation script using QTP & need to generate report using Reporter.report event how we will do it?thanks in advance...
Which date function is used in the vbscript language to find the difference between the 2 dates?
Which operator is used to perform the comparison among 2 operands in the vbscript language?