Robot Framework- Working with Excel Library(Part-1) – User friendly Tech help

ByMatteo

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

Difference between {{}} and ng-bind in AngularJS – User friendly Tech help

ByMatteo

To bind our data to the HTML page, Angular gives the ability to use {{}} known as double curly brackets or ng-bind.Both ways are performing the same functionality.n nn {{}} n Example:-       n name is JS object or some variable we are referring to. n It makes your template very readable i.e Anyone…

How to Encyrpt and Decrypt Password in UFT?

ByMatteo

Requirement: We aim to secure our application’s login password, such as for an Oracle database. Instead of sharing the password directly, we want to encrypt it. When using the SQL query, the password should be decrypted at runtime. Solution: First, we’ll encrypt the password and then decrypt it. Encryption: Approach 1: Using Crypt Utility Object…

Hybrid Framework in Automation (Part-1) – User friendly Tech help

ByMatteo

We started our journey to grasp the concept of framework in automation using keyworddriven approach, today we are going to shape our existing code into a more versatile form known as Hybrid framework.nnNote:- Please read our post on Keyword Driven framework before starting with Hybrid concept.nnFollow us on Facebook for more updates and learning!!! n…

UFT/QTP file Types – User friendly Tech help

ByMatteo

UFT file types:- UFT File Type File Extension Local/Shared Repositories .MTR , .TSR Function Library .QFL, .TXT,.VBS Recovery Scenario .QRS Script file .MTS Environment Variable file .TXT,.INI,.XML Database file .XLS,.MDB Action file .MST Virtual Object .VOT Batch test file .MTB   Full forms of file extensions MatteoWas this article helpful?YesNo

Expand and collapse single Lightning web component Accordion

ByMatteo

Problem: We need an account accordion that can be expanded and collapsed by the user. By default, it should be launched in a collapsed state. Solution: A custom solution was designed by playing with the properties of the current LWC accordion. The key was to use the “allow-multiple-sections-open” property and set the active section “active-section-name”…