Can you import and export data from XLS and how?

Answer Posted / dixit

her i want to add some thing
if you want to import particular sheet then you can use
ImportSheet method

DataTabe.ImportSheet("path of Excel",Source Sheet,Dest
Sheet)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is the resultset of a sqlquery (which is fired by rsobj.open sqlquery,xxxx,xxxx) stored ?

2112


Can we record using all the modes in a single script? Explanation with example is appreciated

1618


Plz Explain How to access Or Store Script from VSS? Explain Real time work (qtp) where you store folders and next to how to you access that folders and how you maintain folders in VSS ? What are the Menu's in VSS? Suppose in Manual, by using Checkin Checkout u can access documents. how you access in QTp REal time?

1799


In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?

1679


How to read a text file from QC using QTP. I would like to do something like this. But instead read a file from QC and NOT from my local drive. Set fso = CreateObject("Scripting.FileSystemObject") Set InputFile = fso.OpenTextFile("C:\test.txt", ForReading) Thanks

3010


The structure of keyword driven frame work is like a folder structure the different sub folder are 1-functional libray folder 2-object repository folder 3- database folder 4-appliction1.xls 5-initalzation vbs file 6-sequence file 7-driver script 8-test case list file My question is whether these are in a local server machine or in our pc.((whether It like Vss). can u give example of driver script(code)

3016


What is the basic concept of quicktest professional?

772


Explain types of output values?

749


Difference between test object and run time object?

775


What is the extension of the recovery scenario file in qtp?

747


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.

1972


How to attach a file to TD?

870


What is the extension of the qtp local repository? If it is .mtr then what is .bdb extension stands for?

790


Who uses qtp tool?

761


Explain about the test fusion report of quicktest professional?

746