How to Import data from a ".xls" file to Data table during
Runtime.



How to Import data from a ".xls" file to Data table during Runtime. ..

Answer / 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

More QTP Interview Questions

how can we do the frame work in qtp

0 Answers   L&T,


from where we will retrieve data for data driven tests in qtp?

3 Answers  


I have a web table,in that web table in 3rd row 4th coloumn i have a link how to click it with descriptive programming? I have a webedit without entering any value how to calculate the size of that field? I have a DB table , how to find the 5th highest salary? write query.

2 Answers   3i Infotech,


did you perform retesting(DATA DRIVEN test) using functions with out using datatable methods how can you perform retesting using functions

3 Answers  


hi this is srinivasa(from blr) i complited my B.tech(e.c.e) in 2007 im searching job in s/w testing but idont have freshers resume for s/w testing please send some s/w testing resume for me(fresfers resumes only) advns thnks you

2 Answers  






How to invoke QTP through VBscript?Send me full code along with description of the code.Thanks in Advance

1 Answers   Capco,


What is the dis advantage of check points in QTP, if any?

6 Answers   BirlaSoft,


Hi Recently I Attend one interview .The intervier ask on Question in QC 9.2 . The Qus was while ruuning the Batch RUNS scripts in test lab if defect will comes .The defect automaticly wants to genate . How to Configure in QC . Thank You Balaji

0 Answers  


How to find given string is palindrome or not without using strreverse() function?

2 Answers  


What is the difference between Dim And Redim

4 Answers   Hotel Jobs, IBM, Microsoft,


How can we disable smart identification at the time of recording? Ideally, smart identification should be enabled only at the run-time.

3 Answers  


str="ramanareddy12345@gmail.com"to count alphabets,numarics and special charcters pls any one knows send to answer

3 Answers   Ziynx,


Categories