cancel
Showing results for 
Search instead for 
Did you mean: 

TestLeft for Excel

Occasional Contributor

TestLeft for Excel

Hello,

 

Has anyone been able to use TestLeft to automate test Excel spreadsheet?

I am not talking about just interacting with ribbon items but interacting within the spreadsheet.

 

Please can you guide me on how to go about doing this.

 

Many thanks in advance

3 REPLIES 3
Highlighted
Community Hero

Re: TestLeft for Excel

Hi,

 

Haven't tried this with TestLeft, but worked with Excel using TestComplete.

TestComplete can drive Excel either via its COM model (preferrable way) or via GUI.

TestComplete interacts with Excel's UI via MSAA. So you need to follow this way with TestLeft as well (https://support.smartbear.com/testleft/docs/reference/options.html#recognition).

You may search TestComplete forum (https://community.smartbear.com/t5/TestComplete/ct-p/TestComplete_forum) for Excel-related questions and port solutions to TestLeft.

 

Regards,
Alex
[Community Expert Group]
____
[Community Expert Group] members are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Postings made by [Community Expert Group] members
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
[Community Expert Group] signature is used with permission by SmartBear Software.
http://smartbear.com/forums/f83/t86934/community-experts/
================================
Highlighted
Occasional Contributor

Re: TestLeft for Excel

Hi Alex,

 

Thanks for the suggestion.

 

TestComplete has the option of Excel Driver but TestLeft does not, hence TestComplete solutions are not applicable in this case.

In TestLeft via MSAA, it only interacts with ribbon items not within the sheet .

Highlighted
Community Hero

Re: TestLeft for Excel

Hi,

 

via MSAA, it only interacts with ribbon items not within the sheet

If I am not mistaken, TestComplete can interact with sheet cells via MSAA as well. Maybe you need to check and try a bit with window class names for MSAA.

 

option of Excel Driver

If you are talking about Excel driver in DDT, then you should use ADO or any other database access technology in TestLeft. Don't forget that tests in TestLeft are actually .Net programs, so you have and may use all the power provided by .Net.

 

Regards,
Alex
[Community Expert Group]
____
[Community Expert Group] members are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Postings made by [Community Expert Group] members
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
[Community Expert Group] signature is used with permission by SmartBear Software.
http://smartbear.com/forums/f83/t86934/community-experts/
================================