The LEAP

Automation insights and productivity tips from LEAPWORK.

All Posts

How to Drive Automation Cases with Excel Data

The "Read Excel" block in LEAPWORK is a major step forward for data-driven test automation, making it very easy to parameterize and drive automation cases with structured and tabular data.

Whether you want to perform smoke tests by picking random test data from an Excel file, or need to loop through thousands of rows in functional test cases, it only takes a minute to start using the "Excel" block.

Read Excel sheet and pick a random row in LEAPWORK

Simply upload an Excel file, select a range and wire up other blocks to use the data within.

Excel sheet range picker in LEAPWORK

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

Related Posts

How to Do a Test Automation Tool Evaluation?

Steep learning curves make it difficult to evaluate automation tools within a reasonable time frame. This can cause the evaluation to drag out and in the worst cases, automation projects are tanked altogether.

Test Automation Best Practices

Most mistakes in test automation are predictable and can be avoided by following best practices. Here's a handful of guidelines to help you achieve success with automation:

How to Ensure GDPR Compliant Data Storage with LEAPWORK

The 2018.1 Release of the LEAPWORK Automation Platform introduces a new Controller – the software that, among other things, stores all the data used in automation flows. With the new Controller, LEAPWORK users can ensure that their data storage in relation to test and process automation is GDPR compliant.