Skip to main content

The XLRD python module for reading excel spreadsheets - Installation

In the last post we have seen the introduction of the xlrd module. If you have missed it, you can see it from here: The XLRD python module for reading spreadsheets files - Introduction. We have seen the problems xlrd development team faced with the dates stored in the spreadsheets and the encoding. 

In this post on Installation we will see how to install the module using pip, easy_install, virtualenv and manual installation

Installation

xlrd module doesn't depend on any third party libraries other than python standard library

pip
If you want to use pip to install the xlrd package then you can do as follows:
$ pip install xlrd

easy_install
You can also install the xlrd package using easy install as follows:
$ easy_install xlrd

virtualenv
You might sometimes have experienced that you want to install two libraries with same name or different versions of the same library. Also you don't want to install certain package to the whole computer but to a certain extent. In these cases virtualenv comes to your rescue. What actually virutalenv does is that it creates an isolated python environment and you can install a given module or package in that isolated place rather than your whole computer. If you want to know more about virtualenv then you can have a look at the official documentation:  Virtualenv
If you want to install xlrd package using virtual environment, then you can do as follows:
cd to the required directory where you want to create virtual environment.
$ cd path/for/installation
Create a directory here if you want:
$ mkdir xlrd
cd into the new directory:
$ cd xlrd
Now create the virtualenv here:
$ virtualenv xlrd-venv
Now we will activate the virtual environment so that we can install our xlrd package:
  • If you are on windows:
    $ xlrd-test\Scripts\activate
    
  • If you are on OSX or any other linux distribution then:
    $ . xlrd-test/bin/activate
    
You will see "(xlrd-test)" at the start of the prompt and this indicates that the virutal environment has been activated.
Now you can simply install the module using pip or easy_install as we have seen previously:
$ pip install xlrd

Manual Installation
You can also install the module by downloading the package from pypi or any other source. First unzip the folder if it is zipped, cd into the folder where the setup.py file is located and do the following:
$ python setup.py install

We have come to an end of this post, I am assuming that you should have used any of the options below and have installed the xlrd module so that we can use it in our further posts. If you are facing any problem installing the xlrd module then you can see more options from here: Installing python Modules

As always I have tried to explain each and every part in this post in such a way that it is easy for everyone to understand. But if you have any doubt or didn't understand anything you can comment in the comment box below or contact me. I will respond to your query as soon as possible. You can contact me from here: Contact me

Please do comment on how I can improve this post so that it will be useful even for beginners. Also comment if I have made any typo or you want me to add any section in this post.


"Knowledge has to be shared, improved, challenged and increased constantly or it will vanish"- Peter F drucker
Thank you, have a nice day!
References:
Webfaction community
Knowledge quotes
installation Flask
The xlrd module
Installing python modules

Popular posts from this blog

Project Euler Problem 67 Solution with Python

Maximum path sum II By starting at the top of the triangle below and moving to adjacent numbers on the row below, the maximum total from top to bottom is 23. 3 7 4 2 4 6 8 5 9 3 That is, 3 + 7 + 4 + 9 = 23. Find the maximum total from top to bottom in triangle.txt (right click and 'Save Link/Target As...'), a 15K text file containing a triangle with one-hundred rows.

Problem 43 Project Euler Solution with python

Sub-string divisibility The number, 1406357289, is a 0 to 9 pandigital number because it is made up of each of the digits 0 to 9 in some order, but it also has a rather interesting sub-string divisibility property. Let d 1 be the 1 st digit, d 2 be the 2 nd digit, and so on. In this way, we note the following: d 2 d 3 d 4 =406 is divisible by 2 d 3 d 4 d 5 =063 is divisible by 3 d 4 d 5 d 6 =635 is divisible by 5 d 5 d 6 d 7 =357 is divisible by 7 d 6 d 7 d 8 =572 is divisible by 11 d 7 d 8 d 9 =728 is divisible by 13 d 8 d 9 d 10 =289 is divisible by 17 Find the sum of all 0 to 9 pandigital numbers with this property. One might write a simple solution using direct if else statements for this problem. Using if else statements, the execution time may be a few seconds. But this is not a very good approach. I too had written a program with if else statement which will take each and every permutation of the 0-9 Pandigital and check for the conditions given in the qu...

Add/Embed SVG to Blogger website

In this post I will tell you my method(trick) of adding SVG images in a blogger website or blog. Before starting , the first thin g I am assu m ing is that you are aware of SVG if you are here. If not please see S calable V ec tor G raphics Recently when I tried to embed a SVG image for a post on pygal, I tried uploading the SVG file and blogger Image uploader came up with an error, because of which I had to find some other way.  SVG File upload Error in Blogger  I started sea rc hing Google " Embed SVG in Blogger " . I found blogorrhea , w h ich gave some i nformatio n on add ing SVG directly as a markup , which worked , but I faced another problem using this . Also th is guy has used lot of Javascript which was confusin g for me, being new to using SVG.   So I first t houg ht of learning on h ow to embed SVG in HTML and t his on e worked out. Actually we can embed SVG in HTML i n following ways: Using Object tag Using Iframe tag Using embed...