CreateObject ,DLL, EXE, Run Time data

[nehasahu]

I have three questions

1)Can You please explain me what is createobject function .....how to and where to use it.

2) What are DLL and EXE files do we use them in QTP.

3) THe data which we trap in the datatable at runtime is lost from the datatable after the program executes.... how to store this data permanently.


Thanks in advance

[ramajkrishna]

1. CreateObject function is to create and return a reference to an automation object.
for example if you want to work with excel then you can create a reference to excel object then later you can apply methods on the reference.
'creating a reference to excel object
set myxls=CreateObject("Excel.Application")
'making excel application visible
myxls.visible=true
'adding workbooks to excel application.
myxls.workbooks.add

3. if you want to store the data that is created in runtime, just keep a statement in your script that exports the data to some external file. like,

datatable.export "C:\myruntimedata.xls"

[nehasahu]

Hi Rama,

Thanks a lot for the answers.
But i still have a doubt on my third question that i dont want to export all the data from the datatable to excel sheet..... i just want to export my third column data to the excel sheet ....So in this case what should be done.

Thanks

[ramajkrishna]

hi neha,
if you dont need other columns in the datatable to be exported to external file, then you can do one thing.
Delete all other columns of the datatable except the one column you want to export.
and then the export the datatable by using export method.

Datatable.GetSheet(" ").DeleteParameter(" ")
Datatable.Export "C:\myruntimedata.xls"

but here the problem is you will lose other columns' data of the runtime datatable.

Thanks&Regards

[nehasahu]

ya rama u are correct i can do that but i also dont want to loose my other data which is there in the datatable.

[ramajkrishna]

Export the entire datatable to one external file and after this delete the parameters you dont want. After this export your column to another external file.
hope this works and clears your problem.

Thanks & Regards
Ramakrishna.Jangatisetty

[nehasahu]

That sounds Great!!!!!!
Thanka a lot Rama

[ramajkrishna]

Thats Great.
hope your problem is cleared