Robotframework-excel is a Robot Framework Library that provides keywords to allow opening, reading, writing and saving Excel files.
- Information about Robotframework-excel keywords can be found on the ExcelRobot-Keyword Documentation page.
- Information about working with Excel files in Python can be found on the Python Excel page.
- Python >= 2.7 | Python >= 3.3
- Robot Framework >= 3.0
- xlutils 2.0.0. Access the downloads here, or use pip install xlutils.
- openpyxl 1.0.2
- natsort 5.2.0. Access the downloads here, or use pip install natsort.
- enum34 1.1.6
The recommended installation tool is pip.
Install pip. Enter the following (Append --upgrade
to update both the library and all its dependencies to the latest version):
pip install robotframework-excel --upgrade
To install a specific version enter:
pip install robotframework-excel==(version)
To uninstall Robotframework-excel use the following pip command:
pip uninstall robotframework-excel
ExcelRobot/base.py
: The Robot Python Library defines excel operation keyword.tests/unit/*.py
: Unit testtests/acceptance/ExcelRobotTest.robot
: Example robot test file to display what various keywords from Robotframework-excel accomplishdocs/ExcelRobot.html
: Keyword documentation for the Robotframework-excel.
To write tests with Robot Framework and Robotframework-excel, ExcelRobot
must be imported into your Robot test suite.
See Robot Framework User Guide for more information.
The test file ExcelRobotTest.robot
, is an easily executable test for Robot Framework using Robotframework-excel.
For in depth detail on how the keywords function, read the Keyword documentation found here : Keyword Documentation
Open a command prompt within the tests/acceptance
folder and run:
pybot ExcelRobotTest.robot -d "./out"
- Lack
DataType
isCURRENCY
andPERCENTAGE
- Not yet optimize performance when saving Excel file after modifying itself
The user group for Robot Framework is the best place to get help. Include in the post:
- Contact the Python-Excel google group
- Full description of what you are trying to do and expected outcome
- Version number of Robotframework-excel and Robot Framework
- Traceback or other debug output containing error information