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

n

n

n

n

n

n

n

Installation:-

n

Using command prompt browse to the location where files are located and use the command.
n
nWindows:-
nSetup.py install

nn

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

nn

natsort

nn

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.

Was this article helpful?
YesNo

Similar Posts