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

How to Import data from a ".xls" file to Data table during
Runtime.

Answer Posted / varun bisaria

Datatable.Import "...XLS file name..."

DataTable.ImportSheet(FileName, SheetSource, SheetDest)
DataTable.ImportSheet "C:
ame.xls" ,1 ,"name"

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

For which type of projects the iterative model is not suitable?

1882


How you are developing the script? Using record and play back or manual?

1057


How many types of parameters are there?

983


If I change the object name in one action will it be updated in all the actions? Or not?

1056


How you debug your script?

1060


hi all can anyone explain how to write the code for finding the mandatory columns in table which are having (red*) (red Astrik)

1858


How can i click on any Excel sheet's "H" column with out writing coordinates Ex:Window("Book1").WinObject("Book1").Click 498,14 I dont want to give coordinates like 498,14 Can i open "H" column by writing like Ex:Window("Book1").WinObject("Book1").Click "H" or Ex:Window("Book1").WinObject("Book1").Click "H","1" or Ex:Window("Book1").WinObject("Book1").Click H,1 If i want to click on "Sheet3" of an excel sheet, Can i open like Ex:Window("Book1").WinObject("Book1").Click "Sheet3" Please help me any one

2090


How you can find length of array in qtp?

1002


How to analyzing test results using quicktest professional?

1163


Differences between quicktest professional (qtp) and winrunner?

1161


write a script for allinterview-submit Question first we've to select Choose Category,second select Sub- Category(Which is comes in to runtime)third select Question Type.for that give some descriptive and vb script

1799


What are the various automation frameworks available in qtp?

974


What is an expert view and keyword view?

1112


What is RTM (require ment tracebulity marix) fromate?

2046


Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in

2012