/VisualTAF

ExlJS - Super easy to use, Excel and JS driven tool, encapsulating best practices in test automation development.

Primary LanguageJavaOtherNOASSERTION

ExlJS (the tool that does most of the work for you in data-driven test automation)

ExlJS is a powerful standalone GUI tool for rapid and super easy creation of data-driven test automation scripts. It's data-driven out of the box, no need to write code for fetching test data. ExlJS allows crafting of test cases in EXCEL by copy/pasting reusable instructions and adding reference to test data in another sheet in the same Excel file.
It gives you great organizational structure and visibility for your test cases, built-in shortcuts make test case automation straight forward (top to bottom approach), smooth and fun, you will waste less brain energy on automation and have more energy for yourself and as a result feeling more happy in your life.

This tool is designed to enforce test automation best practices like reusable data-driven instructions, object repository.

  • It's a standalone GUI tool, no need to remember command line parameters :)
  • it uses Javascript, which is much easier to use than Java or C# code, no compilation required.
  • Tons of built-in convenience functions for all types of interactions with web elements, tons of built-in verification points, you don't need to write any extra code.
  • Do your automated test scripts fail because test data already exists in the system from previous automated test runs? With this tool you won't have this problem, it can automatically generate unique test data every time (no coding required).
  • Parallel test script execution in multiple browsers, instead of hours you can finish test runs in minutes.
  • No need to download and install Node.js, Java, Selenium or other dependencies, the tool is self contained, just download this tool and you are all set, it works out of the box.
  • Built-in Object Repository to keep all Web Elements of your tests in one place (test automation best practices for ease of maintenance in case web element selectors change later)
  • It supports parallel test exection on remote machines.
  • It has sophisticated built-in functions to wait for page load in standard and SPA pages to make your test scripts rock stable.
  • Automatically takes screeenshots upon test failure for easy defect reporting.
  • Automatic Enterprise Level Reporting with drill down to step level (no need for you to write any code), you can see exactly what test data was used for each element and what button was clicked. You can mail this test execution report to project stakeholders for visibility, everybody can see what tests have been executed.
  • !!!New!!! Automatic code generation - just fill in test data in datasheet and press Ctrl+Shift+G for the tool to auto generate code for you, this is the MAGIC hotkey, it will create instruction code, repository with web elements and commands to to interact with them. This hotkey will also navigate you from Excel to exact instruction code and from instruction code to exact web element in object repository, so you don't need to strain your eyes and brain searching in code for instruction or web elements.
  • Save up to 70% on your test automation development and maintenance time.
  • And...It's FREE for personal and educational use. Free training is provided to everybody!

Best practices implemented in this tool in one diagram

Automated test cases in Excel

Video 1: Webinar The simplest method for keyword and data driven test automation, also covers unique test data generation by adding "uniqueN" postfix to test data and verifying data in multi page HTML tables

Video1

Video 2: Watch how I automate data driven test cases in
a matter of minutes using magic hotkey!!!

Video2

You can also see test scripts developed by this tool in this git repo

Installation

  1. Download ExlJS.zip file from this link
  2. Extract content of zip file to some folder
  3. Go to that folder and run ExlJS.exe
  4. Remember to enable macros in excel files in order for magic hotkey to work!

For technical support and questions contact alaserm@yahoo.com
let me know if you have any questions or want a FREE training session via skype or zoom.

List of frequently used built-in functions

each function has documentation, just type its name in tool editor Automated test cases in Excel

Page Element interaction functions

  • clearText
  • typeText
  • select
  • click
  • clickAtXY
  • moveToXY
  • browserAlertBoxClick

Verification functions, checkpoints

  • assertCurrentPageUrl
  • assertCurrentPageTitle
  • assertObjectPresenceState
  • assertObjectVisibilityState
  • assertObjectEnabledState
  • assertObjectSelectionState
  • assertObjectText
  • assertObjectAttribute
  • assertObjectCss
  • assertListSelection
  • assertListContent
  • assertBrowserAlertBoxText

Wait functions

  • sleep
  • waitForStandardPageLoad
  • waitForAngularJQueryJS
  • waitForObjectToBecomeInvisible
  • waitForObjectToBecomeVisible
  • waitForObjectText

Helper functions

  • navigate
  • findObject
  • findRowInHtmlTable
  • isObjectPresent
  • isObjectVisible
  • isObjectEnabled
  • getText
  • getValue
  • getAttribute
  • getCssValue
  • switchToIframe
  • switchBackToDefaultContent
  • switchToNextTab
  • closeCurrentTab
  • selectorAndDescription
  • objectAndDescription
  • reportStep
  • debug
  • executeJSInBrowser
  • maximizeWindow