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
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 to write VB Script for selecting a particular row in a WebTable?
Difference between dim,public and private variables in vb script?
How to Import data from a file (file is on the desktop) to the data table
Explain the asc function?
How can constants be declared in the vbscript language?
did any one attended interview in applabs if you had gone through plz tell me the procedure
How to load vbs functions in qtp
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
Mention how to create a cookie using vbscript?
accept a string & display whether a is present or not
Which is the default Data types in VBScript?
what is the features of visual basic?