DDT using dynamic data from Excel

Help Test Cloud
, , ,
1

Hi,

I am wondering if it’s possible to use DDT (Data-Driven testing) with dynamic data.
I have an Excel file with many sheets and a lot of values changes between each test. I don’t want to update each tests manually using “Update test data”..

Is there still a way to use DDT with these conditions ?

2

Hi @simon.l

Yes, try below steps,
Use Excel Application Scope to open the file.
Get all sheet names using Get Workbook Sheets.
Loop through each sheet with For Each.
Read data using Read Range and pass it to the test case.

If you found helpful, feel free to tick as a solution.
Happy Automation

3

Hi Simon,

Yes, Try to Below steps

  1. Create a Config.xlsx (or JSON).
  2. Store dynamic sheet names or a pattern.
  3. In your test dispatcher, read this config and load the sheets accordingly.

For Ex: {
“SheetPattern”: “TestData_*”
}

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.