Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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

Question Posted / swayam.nayak

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the 2 ways in which a variable can be declared in the vbscript language?

1052

what types of bugs will we find out in banking projects for automation testing?

2220

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("<>") 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

2232

What is the main difference between function and sub-procedure?

1034

If else for do while select in vb script?

1135

I want to run QTP script on Linux server is it possible to do this by connecting Windows to Linux through VPN/Terminal Server and just run the script on Linux server.

2280

Which object is used to work with the database in the vbscript language and what statement is used to create this object?

985

Explain about the extension .hta?

1050

what is inner join? what is outer join? what is a constraint? tell me about rdbms? tell me about acid properties?

1901

Explain the adodb.stream class?

988

Explain about the support of asp for vb script functionality?

926

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

986

give me any information abou vb script books learn quckly

2164

about vb scripting programs this type of all question& answers

2123

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

1926