How to retrieve particular cell data in excel sheet ?without importing method.
Answer Posted / uday
The Question is to retrieve a cell value from Excel sheet.
The method which does this is:
XLSheetObj.cells(rowno,colno).value
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Analyzing the checpoint results?
What is the difference between qtp and selenium?
How to perform cross platform testing and cross browser testing using qtp? Can you explain giving some example?
Hi, I am working on microsoft infopath forms..It is standalone form..(not dotnet or web.) . I am not able to indentify any objects in it.. I am currently using active accessibility in the macro for the same but its execution is too slow.. Kindly help in case you have better solution.
What we are looking for is to load properties of object dynamically as for our application the global repository will pretty huge. It will be really helpful to us if something similar to following functions of Winrunner is available in QTP. #Define descriptor auto strDesc; #set property in the descriptor Gui_desc_set_attr(strDesc,?Class?,?Edit?); --- put other properties #Add Edit box to GUI Map Gui_add(? ?,strWindowName,strEditboxName,strDesc);
What the differences are and best practical application of Object Repository?
Which scripting language used by quicktest professional?
What is meant by Step generator?what is the use of this? we have 3 steps know there what r all those.? can u all pls give me clear idea of this
Explain the checkpoint in qtp?
How to make qtp understand the difference amongst the same type of objects .suppose there are 5 check boxes in a page and I have to choose the 2nd one, how to do that through script?
what is the hierarchy to use properties in descriptive programming
How to run a test using quicktest professional?
Hoe can we do retesting using functions please give the code for it using login page
What is difference between design time and run time data table?
hi all here i have tab named "Workbench" By clicking on "workbench" tab.it displays 4 tabs like below workbench common cargo commercial charter "common" tab have 10tabs inside,"cargo" tab also haveing 15 tabs inside and remaining two tabs also having few tabs inside. when clicked on "common" tab.it displaying the script like tab("workbench").select"common" if i clicked on "cargo".it displaying the script like tab"workbench_2").select"cargo" if i clicked on "commercial".it displaying the script like tab"workbench_3").select"commercial" if i clicked on "charter".it displaying the script like tab"workbench_4").select"charter" I have used a "FOR LOOP" for common,commercial,cargo,charter tabs.it was stopped at second tab SO, CAN I RECOGNIZE "WORKBENCH_2,_3,_4" AS A SINGLE VARIABLE if not, can anyone plese help me to solve this