1. Categories >> Software >> Scripts >> VB Script
  2. Suggest New Category

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

Question Posted / nidhi

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

Have any one know about Test Complete 6, please let me know. If any one have good material regarding Test Complete 6, Please send to my mail id: cns.praveen@gmail.com

1 Answers  

How to write Descriptive programming in .VBS file i wrote this code but it is giving error.. Dim qtApp set qtApp=createobject("QuickTest.Application") qtApp.Launch qtApp.Visible=True Set objIE = CreateObject("InternetExplorer.Application") objIE.visible = True objIE.Navigate "www.gmail.com" browser("title:=gmail").title("title:=gmail")

2 Answers  

I need to get some data from data base and store this (retrieved) data in a excel sheet using VB script in QTP9.0 I have created connection for data base I have created as excels sheet by using Set XL=CreateObject("Excel.Application") XLworksheet.cells(1,1).value= rs.fields.item("<<The data retrieved from data base >>") I have taken a for loop and changed the cells values (1 as i and another 1 as j) But still I am not able to get Plz kindly tell me know this . It is very urgent

0 Answers  

how to retrive the tooltip by using descriptive programming in qtp?

3 Answers   iGate,

Is VBscript case-sensitive?

3 Answers  




How to add actions in driver script to run those actions in QTP?

0 Answers  

What is the difference between javascript and vbscript?

0 Answers  

What is the difference between do until loop and do while loop?

0 Answers  

who you define variables and functions in VB?

1 Answers  

How to identify column in VSFlexgrid? My VSFlexgrid window is identified as 'Active X Control'

0 Answers  

What is Procedure or Subroutine in VB Script?

0 Answers  

w r p syed then output was deys and click eysd and click ysde and click sdey and click deys and click eysd............

2 Answers   Cap Gemini, iGate,

For more VB Script Interview Questions Click Here
Categories