Can anyone help me on how to set the formulas to the Data Table used by the script in the same manner as we set for normal excel sheets.
Did you try something like below?
DataTable("x") = "=A1"
Buy the NEW QTP Descriptive Programming Unplugged Book
** Download QTP Unplugged 2nd Edition eBook for FREE **
You can simply fetch the raw data from the datatable and do your computation work in your script code..if it can serve your purpose.
Thanks and Tarun. Its working now.
But is it good idea to use formula within datatable?
we have seen compatibility issues when working with sheets which has formatting and formula's in them
So watch out during export/import
-- Here to Learn and share ---