cancel
Showing results for 
Search instead for 
Did you mean: 

Excel automation

Highlighted
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
Highlighted

RE: Excel automation

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. ⬇️⬇️⬇️
Highlighted
Frequent Contributor

RE: Excel automation

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.


Highlighted

RE: Excel automation

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. ⬇️⬇️⬇️
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors