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



I want to import the sheet from the Excel to the Datatable using VB Script. I used the Syntax as..

Answer / swayam.nayak

Instead of writing Datatable.ImportSheet "D:Data1.xls","Sheet1","Global" this

Try to put this code

"D:Data1.xls","Sheet1","1"

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More VB Script Interview Questions

I'm new to QTP, i facing a a problem in the script says"Object not found", "Browser("").page("").frame(Name:=fminfo).webtable(). the issue is, QTp is not able to identify the web table in run time.becuase in that fram"fminfo" there are "n"table and the table do not have the names,Html id. 1) i need to count the number webtables available on that page. 2)need to identify the webtable cell values. 3)How Loop the once i get the count and retrive the cell data of each webtable? Can anyone help on this, plz.. Thanks, Suresh

3 Answers  


How do you get the value of a combo box in Javascript?

2 Answers   Aspire,


how to set one column as primary key in QTP and fetch values accordingly

0 Answers   Ford,


how to declare a variable in vbscript using vbscript

4 Answers  


Write program for identifyig duplicates in flight Departing from and Arriving in mercury tours(web application).

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,


How to find arry size in qtp vb script

2 Answers   Cap Gemini,


What are class variables?

0 Answers  


Write a program to resize an array of 5 elements to 4 elements and display all the elements.

1 Answers  


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

3 Answers  


hi what is called GUI in QTP 8.2 and how can we test the apllication using GUI?

0 Answers  


How to select a value from a list box by using Selenium web-driver?

2 Answers   HCL,


Categories