Interested to Buy Any Domain ? << Click Here >> for more details...
How to Import data from a ".xls" file to Data table during
Runtime.
- 1 Answers
- 3801 Views
- Crea, I also Faced
- E-Mail Answers
Answer Posted / ramyab.mca@gmail.com
Hai....
Import data from a ".xls" file to Data table during Runtime:
1.Datatable.Import "...XLS file name..."
2.DataTable.ImportSheet(FileName, SheetSource, SheetDest)
3.DataTable.ImportSheet "C:\name.xls" ,1 ,"name"
K,Byeeee...
Thanks & Regards
B.Ramyasri
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to use parameterization in qtp?
How to modify the text checkpoint?
In qtp, explain what is keyword driven automation framework?
I am having major problems with some DB Table Checkpoints I add to my script. I 35 web based applications recorded and each has DB Table Checkpoints insert but only 1 script isn't recognizing the DB Table Checkpoints for some reason. I've checked the DB connections and the info in the Library Functions and still only this one script out of 35 doesn't recognize the DB Table Checkpoints. Can someone please help me figure out why only this one script out of 35 that's hitting the same database is having a problem.
In qtp, how you can remove the spaces from string?
what could go wrong with test automation?
How you can decide which type of object repository you have to use?
What is the use of Debug Viewer?
What are the advantages of a Hybrid framework?
If an application name changes frequently i.e while recording it has the name, in this case, how do qtp handles?
what is meant by source control?
Is it possible to call from one action to another action in qtp?
how do we know whether all objects are stored in the object repository or not? how can we know if a particular object is not stored in the repository?
I have two For loop, first For loop does is creates a customer and input the customer info and then the second for loop within the first for loop does the follows which is capture the customer name and verify the with the data within the datatable. The problem I am coming across is that when it goes through the second time creating another customer and then verify the second customer then it creates the following during runtime. I want is to have the customer2 below Customer1 under the Customer_from_Apps. Any help will be greatly appreciate it. Customer Customer_from_Apps Customer_from_Apps1 Customer1 Customer 1 Customer2 Customer2 Window("Customer Desktop").Window("Customer Tracking (Privacy").WinObject("TreeView20WndClass").Click 92,244 runtimevalue = .VbTreeView("vbname:=AppServerTree").GetROProperty("Selectio n") Customer_Val= Datatable.GlobalSheet.AddParameter ("Customer_from_Apps",runtimevalue) row=datatable.getsheet("Global").GetRowCount For x=1 to row datatable.SetCurrentRow(x) Data_Val=Datatable.Value("Customer",dtGlobalSheet) If (trim(Customer_Val)=trim(Data_Val)) Then Reporter.ReportEvent micPass, "Customer validation successful", "Actual Value: " &Data_Val&vbcrlf& "Customer Value: " &Customer_Val else Reporter.ReportEvent micFail, "Cusotmer validation unsuccessful", "Actual Value: " &Data_Val&vbcrlf& "Customer Value: " &Customer_Val End If Next
What are the different types of recording modes?
