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

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

Robot Framework with Excel on UNIX


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

Verify Excel library is installed

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

Leave a Reply

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