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...


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

How to open excel in vb script?

0 Answers  


How will you get the octal value of the given number in vbscript?

0 Answers  


Explain about tristate constants?

0 Answers  


Can u describe what kind of testing are for OTC derivates by banks.

0 Answers   BoA,


Mention what is variant in vbscript?

0 Answers  


hi all, i had a question, that how to find out hiding a coloumn in a table i had a table having the following column names NAME DESCRIPTION CREATED TIME CREATED USER if i right clicked on a NAME column it will displays a menu having the same column names in a list like NAME DESCRIPTION CREATED TIME CREATED USER with check boxes.if i unched any check box, that column name should not be appear in the main table column names could anyone please solve this problem?

0 Answers   Livetek,


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

0 Answers  


Give examples where vb script can directly run on users system with windows as os?

1 Answers  


Please let me Know regarding any material regarding VB Scripting which should be easily understandable for Beginners.

0 Answers  


Which object provide information about a single runtime error in a vbscript?

0 Answers  


How to map test cases with Automation script? Please explain in details.With example Thanks for your co-operation(In Advance)

1 Answers   Google, IBM,


Anyone have qtp11.0 crack?

0 Answers  


Categories