Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 6528 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thirupathi ganguly
Hi Akshaya,
This is Thirupathi,iam working on QTP regarding your
question iam sending you answer
If any questions on QTP Call me on my mobile NO. 9922019467
DataTable.ImportSheet "C:\Test1.XLs" 1,1
1- is Destination Sheet ID( to Data Table)
1- is Source sheet id ( from Excel Sheet)
Regards,
Thirupathi Ganguly
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / suresh
datatable.import "D:\Document and setting\test1.xls"
| Is This Answer Correct ? | 1 Yes | 2 No |
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 |
7. Given scenario is like this: One Web table is there and you have to search and retrieve a cell data which is equal to the given number say:123. Assume you have given with the column name/id of the table where the number may exist. So now you have to go to the given column and search for the number 123 and retrieve it along with the row number of it.
Hi all, i have installed QTP8.2 in my system. but script is not generating while recording. What is the problem? is any file missing? pls let me know anybody...Thnaks
I opened gmail login into gmail and i have to save (Pass or move) all the mail into notepad please give me code Thanks of all
RECENTLY I PLACED IN QTP..HOW TO IMPROVE VB SCRIPTS KNOWLEDGE? IAM STRUGGING TO WRITE THE AUTOMATION SCRIPTS? ANY BODY TELL HOW TO IMPROVE QTP SCRIPT SKILLS?
How to find the path of folder in which the test is saved in qtp?
What are output values and why they are used ?
I want to grow as a Automation Engineer,Kindly help me in clearing my interview that what interviewer looks for as a Automation Engineer. I am having three years of experience in testing.
After coming to know that QTP could not identify non-standard objects, we set those non-standard objects as virtual objects using Virtual object wizard. But how can we identify that qtp could not identify non-standard objects?
How to export QTP results to an ".xls" file?
1>How to get the browser name by writing the VBScript. 2>How did you used the GetROProperty and GetTOproperty .give real time scenario. 2>Give and real time ex for the bug having "High Severity and low priority"on banking doamin web based application.
suppose im having a string wipro123xyz i need to get the value 123 only from the string today 123 will be in the middle from tommorow it will be changing to front or back how to get the no if it changes continously?
Does UNIX support QTP? If not what is the other tool used for Unix environment?
WinRunner 
