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
If we take 2 strings as “good” and “bad” then what will ‘+’ and ‘&’ operators return?
Explain the arrays in vb script?
What is the purpose of folders object of scripting.filesystemobject class in vbscript?
write a program to display configuration of a local system with the help of vb script.
Explain about constants in vb script?
How will you get the largest subscript of an array in vbscript?
Mention how to access array data?
Explain about scrrun.dll?
What is the scope of a constant declared using public?
how to set one column as primary key in QTP and fetch values accordingly
How will you get the natural logarithm of the given number in vbscript?
Explain about the support of asp for vb script functionality?
Mention the environments where vbscript could be run?
Mention how you can call vbscript functions?
Explain about .wsf files?