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

[oracleraju]

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]

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]

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

[amitajgaonkar]

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