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
- 7736 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 |
Explain about scrrun.dll?
For a webbased application:- what should be code in expert veiw, for retrieving a single column name "username" from a server and checking whether exported "username" from datatable doesn't exist in server. suppose i have saved in excelsheet a username="gayatri" , which is exported, then checked for whether this username "gayatri" exist in server database or not ? if exist then allow to enter new username, which should be again checked for in loop , or else come out of loop and enter a distinct "username". plz let me have this answer in my id gayatrisahooin@hotmail.com
explain with example primitive data types of vb script.
What's the difference between vbscript and vb.net?
how many types of recording are there?
Hi, Anybody could tell me What is the script for Reverse of Given number. Ex:236--632. Thanks in Advance..
How can I write HTML text to the window in VB Script?
How can I access an object in another frame?
Difference between dim,public and private variables in vb script?
what do you mean .ota mobile format
When does ‘on click of button’ event gets triggered in the vbscript language?
Which object is used to work with the excel sheets in the vbscript language and what statement is used to create this object?
ASP 
