Can you import and export data from XLS and how?

Answer Posted / uday kumar_anem

We can import or export the data from Excel sheet in 2 ways.
1. by using Datatable.import("ExcelFile")
Datatable.export("ExcelFile")
2 Place your mouse over datatable in QTP and right click ->
File -> Import File /Export

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What ate the Technologies supported by QTP?

648


what is the difference between built-i function and In-built function?

1639


Brief the process of testing with UFT?

640


How to use userdifined environment variables.Once we created in Environment tab which is at File--> Settings-- >Environment-->Userdifined

1467


What is text check point and text area check point?

612






Difference between copy to action and call to action?

594


How can i click on any Excel sheet's "H" column with out writing coordinates Ex:Window("Book1").WinObject("Book1").Click 498,14 I dont want to give coordinates like 498,14 Can i open "H" column by writing like Ex:Window("Book1").WinObject("Book1").Click "H" or Ex:Window("Book1").WinObject("Book1").Click "H","1" or Ex:Window("Book1").WinObject("Book1").Click H,1 If i want to click on "Sheet3" of an excel sheet, Can i open like Ex:Window("Book1").WinObject("Book1").Click "Sheet3" Please help me any one

1602


i want information about API testing and i want info like how process can be done in company? i want added info like coding ,debugging, desing in c.v ? what should add in c.v for eg banking domin? pls any answer my question?

1608


Hi am New to Automation Testing , any one can you help me what are the basic questiion are asked an interview?

1425


What are the different attributes used with regular expression?

555


please any one can explain the keyword driven framework. with gmail example.

1629


Explain in brief about the qtp automation object model (aom).

567


What is keyword view?

566


Can we record an application running on a remote machine using qtp?

728


Want to verify notepad reports using QTP framework or any other BV script method. Can anyone share the method to achieve it? Eg. Person Name is the header and the actual name is John then how can we verify weather person name is John

2169