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



in qtp we ve datatable look like excel ,if we want to extract data from excel which saved in my do..

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

in qtp we ve datatable look like excel ,if we want to extract data from excel which saved in my do..

Answer / turtlerock

Datatable.import("c:\one.xls")

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More VB Script Interview Questions

write a vb script to generate 3*3 matrix

2 Answers  


When does ‘on click of button’ event gets triggered in the vbscript language?

0 Answers  


Join the multiple array with out using JOIN function

1 Answers  


How do i automate a website www.flyashx.com without having any test cases witin a week time.

0 Answers   Zensar,


How strcomp function works?

0 Answers  






Is vbscript a case-sensitive or case-insensitive?

0 Answers  


Mention how to access array data?

0 Answers  


this q asked in applabs, q is: QTP should open google.com page and enter "qtp" in one edit(search) box and click search and should open google.com again and enter "job" in edit(search) box and click on search. I tried this but getting error "Edit(search) box matches more than one object", could anyone this question plz..

1 Answers   AppLabs,


i want to when we will write the scripts either after getting the build or after getting the SRS?

3 Answers  


Why to add checkpoint in QTP What's the purpose of checkpoints & how to add it

2 Answers  


To get data from table which method will be used in QTP

3 Answers  


Write a vbscript procedure that converts feet to inches. Hint: there are 12 inches in a foot?

0 Answers  


Categories