Interview Questions Answers in VB Script

swayam prakash

{ City } kolkata
< Country > india
* Profession * test analyst
User No # 108466

Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0

Questions / { swayam prakash }

Questions Answers Category Views Company eMail

Answers / { swayam prakash }

Question { 3308 }

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

Answer

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

Question { IBM, 3159 }

How to Import data from a file (file is on the desktop) to
the data table

Answer

By Using Datatable.Importsheet

Is This Answer Correct ?

0 Yes

0 No