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
- 3419 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
I have attended Anovatek Software QTP interview. They will give us computer and one web based application with QTP. We have to automate some records (already updated records or new records) using QTP Data driven testing. But we should use for loop? Can any one know how to do data driven testing using For loop?
Mention the rules for using option explicit statement?
How will you convert a string to lower case string using vbscript?
Can automation testing find ssame no. of bugs what we can find by manual testing?
Can someone please tell me what poor design in a relational database (not the layout or style) is and how it can be avoided? PLEASE...im desperate.
Mention when to use function procedures and what are its characteristics?
Mention the environments where vbscript could be run?
What are subprocedures in vbscript?
Write a function for Instr(). We need to write a function that works as same as Instr(). Code or Even pseudo code is good enough for me.?
How to write a VBscript for web page performance test i need a code send if any knows the code If any knows VBScript book plz send to me the link to my mail plz
How to pass argument by reference to a function in vbscript?
how to operate webobjects in a webpage using getobject function and then using generic methods?
i need to sort the data using qtp script for this how i need to write a qtp script
Like OPTION EXPLICIT statement what are the other statements used in vbscript and their usage. Please post me all the statements please.
1.I want to establish connection with excel and also want to fetch the data using SQL queries. 2.the code should be written in such a way that in future if I want to migrate from excel to MS excess database , then there should be minimal changes.
