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

Can you import and export data from XLS and how?

Answer Posted / uday kumar_anem

We can import or export the data from Excel sheet in 2 ways.
1. by using Datatable.import("ExcelFile")
Datatable.export("ExcelFile")
2 Place your mouse over datatable in QTP and right click ->
File -> Import File /Export

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find Operating system information using QTP script?

1055


in a web page How to check and display a particular word from a paragraph?

2540


how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods

1981


Does any one worked on JIL Emulator , Testing with QTP(automation). Trail Version of QTP is not identifying the child objects of JIL emulator, Can any one help me out ,

1937


What is quick test pro?

1100


How can you close the second opened browser?

1495


I am facing an issue of object identification with the dropdown element of DHTML grid. When I tried to recognize these different dropdown objects, QTP identifies only one object for all the dropdowns. Hence, selection of different data from different dropdowns list is an issue. To overcome this problem, i have used Descriptive Programming technique by creating different object descriptions which have all the other properties same but differ only in one property i.e. ‘X’ location of the element on the screen. Hence, i have created distinct object descriptions that would allow us to select values in different dropdowns. The code is given below. But still I am unable to identify distinct dropdown objects. ‘Object Description for Dropdown Cell Status Set objCellStatus = Description.Create objCellStatus("micclass").value = "WebList" objCellStatus("name").value = "select" objCellStatus("x").value = 219 ------ ‘X’ Axis value for cell status drop down ‘Object Description for Dropdown Sub Segment Set objSubSegment = Description.Create objSubSegment("micclass").value = "WebList" objSubSegment("name").value = "select" objSubSegment("x").value = "319" ------ ‘X’ Axis value for sub segment drop down Please help... This is specific to DTML grid(Drop down object)

1967


how can we compare descriptive programing with a regular expression

2457


How to automate a script in mainframes environment? I have the terminal emulator Add in. Describe in detail.

2315


Will there be any standards or requirements for page appearance and/or graphics throughout a site or parts of a site?

1083


How to release all resources file from the QTP?

1620


How can you identify the browser and its information using the qtp script?

1063


can any body plz help by sending the qtp docs and qtp ppt's? this is my mail id:murali.padeti@gmail.com

2288


What are the views available in quicktest professional?

1076


When do go for loop condition in test?

1150