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

Popular posts from this blog

Making a quiz web app with python and flask

Edit : When you are creating a web app with h tml templates, then y ou will have to sa ve the html file in templates folder in the Current Wor ki ng Directory( CWD). If you save the file in the C W D directl y you will get a TemplateNotFound error. Thank you Udhay for pointing it out.   In this post we will create a quiz website using python . I will be using the flask framework . After reading this tutorial you will learn form submission , flask templates , python code in flask templates , shuffling the questions and options with the random module and few others.  Please note that this tutorial is not big as it seems to be. Some of the code has been rewritten to maintain consistency and also font size is somewhat big so that your eyes won't get stressed reading this tutorial. Also the content has not occupied the full width of the page. In this tutorial I am assuming that you are having a very basic understanding of the flask framework . Please refer the documentation
Read more

Problem 11 Project Euler Solution with python

Largest product in a grid In the 20×20 grid below, four numbers along a diagonal line have been marked in red. 08 02 22 97 38 15 00 40 00 75 04 05 07 78 52 12 50 77 91 08 49 49 99 40 17 81 18 57 60 87 17 40 98 43 69 48 04 56 62 00 81 49 31 73 55 79 14 29 93 71 40 67 53 88 30 03 49 13 36 65 52 70 95 23 04 60 11 42 69 24 68 56 01 32 56 71 37 02 36 91 22 31 16 71 51 67 63 89 41 92 36 54 22 40 40 28 66 33 13 80 24 47 32 60 99 03 45 02 44 75 33 53 78 36 84 20 35 17 12 50 32 98 81 28 64 23 67 10 26 38 40 67 59 54 70 66 18 38 64 70 67 26 20 68 02 62 12 20 95 63 94 39 63 08 40 91 66 49 94 21 24 55 58 05 66 73 99 26 97 17 78 78 96 83 14 88 34 89 63 72 21 36 23 09 75 00 76 44 20 45 35 14 00 61 33 97 34 31 33 95 78 17 53 28 22 75 31 67 15 94 03 80 04 62 16 14 09 53 56 92 16 39 05 42 96 35 31 47 55 58 88 24 00 17 54 24 36 29 85 57 86 56 00 48 35 71 89 07 05 44 44 37 44 60 21 58 51 54 17 58 19 80 81 68 05 94 47 69 28 73 92 13 86 52 17 77 04 89 55 40 04 52 08 83 97 35 99 16 07
Read more

Problem 60 Project Euler Solution with python

Prime pair sets The primes 3, 7, 109, and 673, are quite remarkable. By taking any two primes and concatenating them in any order the result will always be prime. For example, taking 7 and 109, both 7109 and 1097 are prime. The sum of these four primes, 792, represents the lowest sum for a set of four primes with this property. Find the lowest sum for a set of five primes for which any two primes concatenate to produce another prime. This problem is j u st a brute force problem. If you have come here because you don't know the limit upto which you will h ave to gener ate the prime numbers t hen go ahe ad and t r y with 10,000 . When I first start ed solving the problem I chose 1 million(beca use most of the problem s on project E uler have this limit ), but it took very long for the computer to fin d the solution. After searching on the internet then I found many people choosing 10, 000 so I have changed my in put f rom 1 million to 10000 and the output was f ast. He
Read more