The LEAP

Automation insights and productivity tips from LEAPWORK.

All Posts

How to Use Live Excel Data for Dynamic Automation

Driving automation in LEAPWORK with pre-defined data from an Excel file is easy with the Read Excel block. But sometimes you need more real-time access.

For instance, if you routinely change the data in the Excel file before running your automation cases, re-adding the file every time can be cumbersome. The changes can even be made by other people in your organization who are not involved in the automation process.

You may also want to write results or other data back to the Excel file for further processing later. For instance, you can update the same Excel file every day with more and more results and even use it as a human-readable format for exchanging data between different systems.

The following is an example of how Excel files can be used as a live data source in LEAPWORK and how to read and write to it using a Database block with an ODBC connection.

 

Using an ODBC connection to Excel (or a csv- or txt-file for that matter) can be a powerful way to read, manipulate and write data.

The ODBC query syntax can unfortunately be somewhat confusing, and documentation from Microsoft is sparse. The following are a few links to articles and blog posts where the Excel ODBC driver is discussed:

Claus Topholt
Claus Topholt
CTO and co-founder of LEAPWORK.

Related Posts

How to Analyze Test Automation Results

As test automation is introduced to the software delivery process, the amount of available test results explodes. Robots, or test execution agents, can run 24/7 without breaks, and, on top of this, the number of test cases accumulate during each sprint. As such, more results are produced to be managed and analyzed. This requires the right approach.

Test Automation Strategy: A Checklist

Too often, test automation is not handled as a strategic choice as there’s too much focus on putting out fires here and now. Test automation is a cornerstone in DevOps, and when implemented correctly, it helps increase output quality while containing costs. Not surprisingly, IT departments everywhere are realizing the importance of having an actual test automation strategy.

5 Failures in Test Automation – and Best Practices for Tackling Them

Too many test automation projects fail – and often for predictable reasons. To help you avoid these pitfalls, we have condensed the most common issues into this short guide along with related best practices for achieving success with automation.