Hi All,
I'm Akshaya here, could anybody please help me regarding
how to import the excel sheet to run time datatable. But
Pl. keep it in your knowledge is that excel sheet is opened.
Thanks,
Akshaya Madali
9823213538
Answer Posted / siraj
FOR IMPORTING PARTICULAR SHEET FROM THE EXCEL BOOK.
--------------------------------------------------
Datatable.importsheet "D:\test1.xls",1,1
FOR IMPORTING WHOLE EXCEL BOOK(DEFAULT 3 SHEETS)
------------------------------------------------
Datatable.import "D:\test1.xls"
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to Upgrade or support firefox 2.0 version on QTP 9.0? I have installed QTP 9.0 and installed firefox 2.0. But in REcord and Run Settings, it shows firefox 1.5 in Web tab for browser selection.
What is checkpoints for quicktest professional?
How may types of defects identify application or your currently working application?pls give me answer..
How many types of actions are there in quicktest professional?
What is the keyword view and expert view in qtp?
What is contained in the object repository?
When should I use smart identification?
can i compare two databases using QTP ?
Explain in brief about the quicktest professional (qtp) automation object model?
Hi, I got error message as "object does not support this property or method: "Test.Actions" when i execute the following line of script on QTP 9.0 Dim qtApp, qtRep Set qtApp = CreateObject("QuickTest.Application") Set qtRep = qtApp.Test.Actions("Action1").ObjectRepositories Can anyone tell me where i am wrong.
How many ways we can parameterize data in quicktest professional (qtp)?
How to do the scripting. Are there any inbuilt functions in QTP? What is the difference between them? How to handle script issues?
I used the below code to open QTP through VBscript?But i can unable to Invoke QTP...PLZ help me with the correct code to invoke QTP through VBS with description of the code aswell. Dim qtApp 'As QuickTest.Application 'Declare the Application object variable Dim qtTest 'As QuickTest.Test 'Declare a Test object variable Dim qtResultsOpt 'Declare a Run Results Options object variable Set qtApp = CreateObject("QuickTest.Application") 'Create the Application object qtApp.Launch 'Start QuickTest qtApp.Visible = False 'Make the QuickTest application visible qtApp.Open "C:\form", True 'Open the test in read-only mode 'set run settings for the test Set qtTest = qtApp.Test qtTest.Run 'Run the test 'WScript.StdOut.Write "Status is: " & qtTest.LastRunResults.Status 'Check the results of the test run qtTest.Close 'Close the test qtApp.quit 'Close QuickTest Pro Set qtResultsOpt = Nothing 'Release the Run Results Options object Set qtTest = Nothing 'Release the Test object Set qtApp = Nothing 'Release the Application object
Explain how you can find the absolute value of the number in qtp?
How did you resolve conflicts present in Object Repository?