Automating Excel Formulaes

Can we automate the process of performing some Excel Formulaes (like concatenating columns,adding columns) through QTP. If so then how ?


NOTE : [I][This question was asked by Satish, I am posting it in proper forum] [/I]

In QTP cannot perform the excel commands.

but we can do the same commands from different ways through VB-Script.

Thanks
Srinivasulu.Chittoor

[QUOTE=JobHelper;4095]Can we automate the process of performing some Excel Formulaes (like concatenating columns,adding columns) through QTP. If so then how ?


NOTE : [I][This question was asked by Satish, I am posting it in proper forum] [/I][/QUOTE]

Yes we can do it using Data table.