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
- 7444 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 |
a;;b;c;;;d in this string output is abcd will come how can we do that in vbscript in QTP testing?
How will you reverse a string in vbscript?
can anyone send me a vb scripts code for clicking on a link and coming back on home page again does the same for many links on a web page.
who will create the object?
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
What is the difference between do until loop and do while loop?
Mention what is the technology used by vb script?
How will you compare two strings in vbscript?
How are values assigned to the variables in the vbscript language?
What are the differences between sub procedures and function procedures?
write a vbscrpit to swap values
How can I get the value of an object property or variable in another frame?
ASP 
