Robot Framework

Installation







Read data from Excel

Manual Installation

To install robotframework-excellibrary manually, install all dependency libraries before installing robotframework-excellibrary.
1) Install Robot Framework installed.
2) Download source distributions (*.tar.gz / *.zip) for the library and its dependencies.
robotframework-excellibrary and dependencies:

• https://pypi.python.org/pypi/robotframework-excellibrary
• https://pypi.python.org/pypi/xlutils/1.7.1
• https://pypi.python.org/pypi/natsort/3.3.0

Note: Internet Connection is required

command

python setup.py install

***Settings***
Library    ExcelLibrary

***Variables***
${Excel_File_Path}    C:\Test.xls

***Test Case***
Read Data from Excel and fill in text box
    Open Excel    ${Excel_File_Path}
    ${username}=     Read Cell Data By Name    Sheet1    B1
    ${password}=     Read Cell Data By Name    Sheet1    B2
    Input Text    id=Username    ${username}
    Input Text    id=Password    ${password}