How to Import data from a ".xls" file to Data table during
Runtime.
- 10 Answers
- 25620 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / varun bisaria
Datatable.Import "...XLS file name..."
DataTable.ImportSheet(FileName, SheetSource, SheetDest)
DataTable.ImportSheet "C:
ame.xls" ,1 ,"name"
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use debug tools?
When and why to use descriptive programming?
Define object spy ?
Where to use function or action?
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
How to suppress warnings from the test results page?
Is it possible to call from one action to another action in qtp?
How to data driven test for Win objects in QTP ?
This is a question thats generally asked in every QTP interview. What were the problems that you faced during automation and how did you resolve them?
What are the features and benefits of quick test pro (qtp 8.0)?
what is the frame work in J-meter?
hi all can any body explain how to write the script for finding the mandatory fields which are having [red Astrik sign (*)]
Name the properties you would use for identifying a browser and page when using descriptive programming?
In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?
Plz Explain AUTOMATION REFERENCE MODEL?
