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?
Write a Program to add 2 numbers without using operators (+,-) and without using third variable. Note: Use VBScript only Hint: You can use other operators like '/' & '*'(Division & Multiplication)
How can you destroy an object in vbscript?
What are the differences between sub procedures and function procedures?
When to use function procedures and what are its characteristics?
Explain vbscript in detail?
Explain about scrrun.dll?
Hello friends..... Can any give the methods for Ms-Access, and Mozilla firefox in Automation Object Model in QTP. Please give me currect answers... if you do not understand my question please don't give answers. Thanking you.
How do i automate a website www.flyashx.com without having any test cases witin a week time.
How many types of procedures are available in the vbscript language?
Mention what is the use of option explicit in vbscript?
what is resorceallocation
Write a vbscript procedure that converts feet to inches. Hint: there are 12 inches in a foot?
How to capture a runtime error in vbscript?
Explain about arrays in vb script?