Robot Framework- Working with Excel Library(Part-1) – User friendly Tech help
In part-1 we would discuss on Installing Excel Library to work with Robot Framework.
n
True Success is balance. For me, this means Health, Wealth, Happiness.
n
So I try and get 1% better each week in each of these areas.
n
Lets learn the robot framework integration with Robot Framework to enhance our skills.
n
Scenario: – How we can install Excel Library to work with excel files using Robot Framework.
n
Solution:-
n
Download:-
n
Excel Library: – http://navinet.github.io/robotframework-excellibrary/
n
Dependencies:-
n
Natsort :- https://pypi.python.org/pypi/natsort/3.3.0#downloads
n
Xlutils:- https://pypi.python.org/pypi/xlutils/1.7.1
n
Xlrd:- https://pypi.python.org/pypi/xlrd
n
Xlwt:- https://pypi.python.org/pypi/xlwt
n
After extracting all the files we need to install all of them:-
n
 |
n
Installation:-
n
Using command prompt browse to the location where files are located and use the command.
n
nWindows:-
nSetup.py install
n
n
nRepeat the above process for all the dependencies.
n
nLinux:- 
n
Verify:-
n
We can check that we have successfully installed all the individual components by typing python, followed by import “folder Name” in the command window after the installation.
n
For example:-
n
ExcelLibrary
n
n
natsort
n
n
Note: – We cannot use .xlsx extensions, due to limited support thus we need to stick to .xls extension(Excel 97-2003).
n
In our next post we are going to explore more on Excel integration with Robot Framework.
