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 { 2580 }

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, 2422 }

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