Forum Discussion

VinnyK's avatar
VinnyK
Occasional Contributor
6 years ago

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 y...
AlexKaras's avatar
AlexKaras
Champion Level 3
6 years ago

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's avatar
    VinnyK
    Occasional Contributor
    6 years ago

    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's avatar
      AlexKaras
      Champion Level 3
      6 years ago

      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.