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.
After extracting all the files we need to install all of them:-
Downloaded files of Excel library

Using command prompt browse to the location where files are located and use the command.

Windows:- install

Installing Excel Library in Robot Framework

Repeat the above process for all the dependencies.


Robot Framework with Excel on UNIX

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


Verify Excel library is installed


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 thought on “Robot Framework- Working with Excel Library(Part-1)”

Leave a Reply

Your email address will not be published. Required fields are marked *