Robot Framework- Working with Excel Library(Part-1)

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:-

Natsort :- https://pypi.python.org/pypi/natsort/3.3.0#downloads

Xlutils:- https://pypi.python.org/pypi/xlutils/1.7.1

Xlrd:- https://pypi.python.org/pypi/xlrd

Xlwt:- https://pypi.python.org/pypi/xlwt

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

Installing Excel Library in Robot Framework

Repeat the above process for all the dependencies.

Linux:-

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

Verify Excel library dependencies are installed

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)”

Leave a Reply Cancel reply