TestLeft for Excel

[VinnyK]

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

[AlexKaras]

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.

[VinnyK]

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 .

[AlexKaras]

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.