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

in qtp we ve datatable look like excel ,if we want to
extract data from excel which saved in my documet how can i
get that in datatable using vb script

Answer Posted / jyotikrushna mohapatra

You can do by just parameterizing it.Let's explain with an
example. You have a datatable let table.xls in C drive and
if you want to extract the data from this excel file into
your document then write in the pane

datatable.importsheet "C:\\table.xls",1,destination

Here destination means where u have to place the data

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi i am trying for testing job for 3+ experience(fake) can u suggest me what type of projects i can keep in my resume and how much of knoeledge i should have abt that project.thnks in advance.urgt plz

2991


How to take whole text output from screen of Bitmap Application.

2371


Explain the scope of the variables using dim, public, and private keywords respectively.

1158


How to assign a numeric value to a variable?

1125


How many types of procedures are available in the vbscript language?

1001


What is loose binding? Why is it not a good practice to use it?

1108


Write a vbscript procedure that converts feet to inches. Hint: there are 12 inches in a foot?

1045


Explain about tristate constants?

1024


How will you convert a given number to long in vbscript?

883


Hi this is Vinoth. I need a help on below mentioned question A combobox contains list of items assume as 5 I have to get each items Individually and I have to Export to datatable. Please help me on this. Thanks

2131


Explain about vb script?

1226


Description.Create

2648


Does VB/Win make standalone .EXE files?

3402


how to operate webobjects in a webpage using getobject function and then using generic methods?

3111


How can you destroy an object in vbscript?

1115