Ask a Question

Excel automation

sarya
Frequent Contributor

Excel automation

Hi,



I wanted to know how far can we automate the excel files verification .Currently I am doing excel files compare but I have different scenarios where I want to verify the published excel files on the server website .Manually I have to verify whether the settings (font, page size, data comparison) .Can excel be automated to this extent where I do not need to perform any verification manually ?



Thanks,

Sumedha
3 REPLIES 3

Hi Sumedha,


There are no special checkpoints for Excel documents in TestComplete if that's what you mean. If you need to perform a comparison, I recommend that you create a script which uses the Excel COM object.



Best regards,
Alexey

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
sarya
Frequent Contributor

Okay,so I can only perform excel file comparison in the excel . What else operation can be done using excel COM as my testing needs to extensively test excel files as in is the data correct ,did the format chnage had gone through correctly etc.



Thanks.


Hi Sumedha,


We provide support for TestComplete, not for Excel, actually. You can find information on the Excel object model in multiple MSDN Library articles, for example:

http://msdn.microsoft.com/en-us/library/bb332345.aspx

http://msdn.microsoft.com/en-us/library/aa272268(office.11).aspx


Information on sample projects demonstrating how to get the Excel COM object in TestComplete can be found in the "MSOffice" section of the "Script Samples" ( http://www.automatedqa.com/support/viewarticle.aspx?aid=3425 ) help topic.



Best regards,
Alexey

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
cancel
Showing results for 
Search instead for 
Did you mean: