in qtp we ve datatable look like excel ,if we want to
extract data from excel which saved in my documet how can i
get that in datatable using vb script
- 2 Answers
- 7440 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jyotikrushna mohapatra
You can do by just parameterizing it.Let's explain with an
example. You have a datatable let table.xls in C drive and
if you want to extract the data from this excel file into
your document then write in the pane
datatable.importsheet "C:\\table.xls",1,destination
Here destination means where u have to place the data
| Is This Answer Correct ? | 2 Yes | 1 No |
How can you destroy an object in vbscript?
Explain the support of asp for vb script functionality?
What purpose does ‘on error resume next’ serves?
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
how to find the textfile in the folder and copy file from one folder to another folder useing parameterigation in QTP
What is the use of option explicit statement?
How to get the length of the string by making use of the string function?
Hi this is Vinoth. I need a help on below mentioned question A combobox contains list of items assume as 5 I have to get each items Individually and I have to Export to datatable. Please help me on this. Thanks
What is Querystring collection?
Hi, Anybody could tell me What is the script for Reverse of Given number. Ex:236--632. Thanks in Advance..
Can automation testing find ssame no. of bugs what we can find by manual testing?
What is vbscript?
ASP 
