Learning Robot Framework : Data Driven Testing

Read Data from Excel (openpyxl)

import openpyxl
workbook = openpyxl.load_workbook("./TestKeyword.xlsx")


def fetch_number_of_rows(sheetname):
    sheet = workbook[sheetname]
    return sheet.max_row


def fetch_cell_data(sheetname, rownum, cellnum):
    sheet = workbook[sheetname]
    cell = sheet.cell(rownum, cellnum)
    return cell.value


print(fetch_number_of_rows("Sheet1"))
print(fetch_cell_data("Sheet1", 1, 2))

Excel

Create User Defined Keywords

Run loop and Read data from keywords

    ${row} =  Read Number of Rows    Sheet1
    
    FOR    ${i}    IN RANGE    1    ${row}+1
        Log    ${i}
        ${searchkeyword}=  Read Excel Data of Cell  Sheet1  ${i}  1
        Log To Console    ${searchkeyword}
    END

github.com