Hi, I have a data spreadsheet that is imported and some of the cells have formulas in them. When the tests have run the data sheets are exported back into excel, but I loose the formulas.
Is there any way that the formulas can be kept within excel?
Check with HP Support. I am not sure if it supported or not
Tarun Buy the NEW QTP Descriptive Programming Unplugged Book ** Download QTP Unplugged 2nd Edition eBook for FREE **
Skip the import/export step and just work with the excel sheet in place with the excel object.
I am not sure if something has changed in QTP 10, because the in the past this is a know limitation if i can call so.
Moreover, there was thread in which Tarun had indicated that datatable is a custom control and not dependant on excel, search the forum and you may get the answer.
Corruption of files usually occurs when formats change or sometime due to presence of formula's also, and the dreaded General error would be thrown during export/import.
Better way is to work with excel objects as point by NoUse4aName
-- Here to Learn and share ---