In part-1 we would discuss on Installing Excel Library to work with Robot Framework.
True Success is balance. For me, this means Health, Wealth, Happiness.
So I try and get 1% better each week in each of these areas.
Lets learn the robot framework integration with Robot Framework to enhance our skills.
Scenario: – How we can install Excel Library to work with excel files using Robot Framework.
Solution:-
Download:-
Excel Library: – http://navinet.github.io/robotframework-excellibrary/
Dependencies:-
After extracting all the files we need to install all of them:-
Installation:-
Using command prompt browse to the location where files are located and use the command.
Windows:-
Setup.py install
Windows:-
Setup.py install
Repeat the above process for all the dependencies.
Verify:-
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.
For example:-
ExcelLibrary
natsort
Note: – We cannot use .xlsx extensions, due to limited support thus we need to stick to .xls extension(Excel 97-2003).
In our next post we are going to explore more on Excel integration with Robot Framework.
One reply on “Robot Framework- Working with Excel Library(Part-1)”
Nice post sir.I am very happy to find your neat and clean documentation.but i am getting an error during setup.py install could you please resolve this.