Interested to Buy Any Domain ? << Click Here >> for more details...
Hi, how can we retrieve a specific value from Excel Sheet
(Not datatable. for externel file).i mean to say from .xls
file.
and also tell me from xml file and .doc file.
and how can u parameterize ur script from .xls file.(Not
data table).
- 2 Answers
- 8431 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Hi I can divide ur question in to 3 parts
1. for xls file
2. for xml file
3. for doc file
1. For xls it is
GetCellData (Row, Column)
2. For XML
XMLFile(description).GetData
3. For Doc file it is
ReadLine( )
Any more querys in this then feel free to mail me to
testingwithshyam@gmail.com
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / nidhi jain
first you need to import datatable
Datatable.import("datatablename with path")
after importing table you need to call get method
Datatable.getCellData('columnname','datatable type')
| Is This Answer Correct ? | 1 Yes | 4 No |
CAN WE USE 'BVA' AND 'ECP' IN AUTOMATION?
What are the different attribute used with regular expression?
how do find current links in webpage for ex: in yahoowebsite today mainpage is having 50 links and next day same page is having 60 links. if i run same programe it should display total links in webpage ?
Howcan you differentiate between Exist statement, Exist property, and Exist method??? How they used???
Any one please tell me how to create framework in QTP (in detail). Is there any website for reference?
Can any one brief some detail on how the shared and action object repository utilized/implemented in a real time project. I already know how to make shared object repositor by saving OR as .tsr extension..I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thanks
Hello, I am working on automating unix application using QTP via terminal emulator.Recording and playback works as i execute my test case. I need to parameterise my data now. Steps to be followed 1. go to the application TeWindow("TeWindow").Window("Connect").WinButton ("Connect").Click 2. Make a transaction to an account I am able to make transaction one at a time (one person when i run the script) and the script is as below and works fine. TeWindow("TeWindow").TeTextScreen ("TeTextScreen").Type "./4ee.sh" TeWindow("TeWindow").TeTextScreen("TeTextScreen").Type micReturn TeWindow("TeWindow").TeTextScreen("TeTextScreen").Sync TeWindow("TeWindow").TeTextScreen ("TeTextScreen").Type "a21100002" TeWindow("TeWindow").TeTextScreen("TeTextScreen").Type micReturn TeWindow("TeWindow").TeTextScreen("TeTextScreen").Sync TeWindow("TeWindow").TeTextScreen ("TeTextScreen").Type "tcccc" TeWindow("TeWindow").TeTextScreen("TeTextScreen").Type micReturn TeWindow("TeWindow").TeTextScreen("TeTextScreen").Sync TeWindow("TeWindow").TeTextScreen ("TeTextScreen").Type "test" TeWindow("TeWindow").TeTextScreen("TeTextScreen").Type micReturn TeWindow("TeWindow").TeTextScreen("TeTextScreen").Sync TeWindow("TeWindow").TeTextScreen("TeTextScreen").Type micF1 TeWindow("TeWindow").TeTextScreen("TeTextScreen").Type "6" TeWindow("TeWindow").TeTextScreen("TeTextScreen").Type micF1 TeWindow("TeWindow").TeTextScreen ("TeTextScreen").Type "xexit" TeWindow("TeWindow").TeTextScreen("TeTextScreen").Type micReturn TeWindow("TeWindow").TeTextScreen("TeTextScreen").Sync 3. Now i need to Make a transaction to the account for the list of people available from data table. How do i do this? Please let me know if you can Thanks, Chaya
On what document base Descriptive programming is written if build is not yet ready ?
Explain synchronization types in QTP
Hi,All How to change background color of a cell in excel using qtp and that too with out using Excel Object.(I am importing the excel sheet by using ImportSheet method)
What is Description Object?
How exactly you start scripting in QTP? In the interview he was not satisfied with my answer.Please post what is correct answer.
WinRunner 
