Saving a data in excel sheet....Using QTP

oracleraju · #1 (**permalink**) 08-18-2005, 07:13 AM

Hi,
How i can save a data in excel sheet for future use.
I was able work on the data in the excel sheet,but i was not able to save the dynamic data in the excel sheet permanently.

Regard's,
Raju KH

amitajgaonkar · #2 (**permalink**) 08-30-2005, 03:29 AM

just right click in the sheet
1. you get 5 options file , sheet etc ...
2. select Sheet > export > and save accordingly.
3. the file is saved as Excel sheet and is exact replica of the datagrid.

cheers
Amit

oracleraju · #3 (**permalink**) 08-31-2005, 02:47 AM

Actually my query is regarding the storing of run time data in datatable.

amitajgaonkar · #4 (**permalink**) 09-02-2005, 06:20 AM

oh!!! was it that i told u some elementary method of saving a spreadsheet?
ok sorry for that.

When u say"Actually my query is regarding the storing of run time data in datatable.", thats more clear

simply use the following statement "datatable.export" , in other words use/insert this statement at the end of the testcase.

hope u get this clear.

Thanks

Amit