Skip to main content

xlrd python module for reading spreadsheets - Read the docs

xlrd module is a python module and is used for working with excel files or spreadsheets.
If you have seen the title I have named this post with Read the docs at the end. Do you know why?
python xlrd documentation or tutorial
python xlrd module documentation/tutorial
Okay I will tell it to you. The first time I used python I got in love with this programming language the same way you fell in love with it. But one day I wanted to convert data in excel sheet to a dictionary for my computations. I thought that I could consider excel sheets as python file objects and proceed with computation. But this method of using excel files as file objects didn't work

So I typed "Excel with python" in google and the results I saw were these:
Google search results for "Excel with python"
Google results for "Excel with python"
 I chose the second result because the name(title) was obvious and I found the xlrd module. I clicked on the documentations and expected this kind of documentation:
Documentation for a python module using read the docs - The style which I expected
Read the docs documentation style
 But what I saw was this:
xlrd official documentation page
xlrd official documentation page
 This official documentation didn't have any quickstart or any introduction but the code was introduced directly. Because of this I was not able to use the module directly. 

After few days I finally have learned the usage of xlrd module. But at some corner of my heart I felt the requirement for readthedocs style documentation. Even though documentation for read the docs is generated using sphinx, what I finally decided was that I should write one neat introduction, installation and quickstart so that people can get benefitted from these.

The result is what you are seeing. If you are here to learn the xlrd module easily then you are at correct place and you can access the following links to see introduction, installation and quickstart.
  1. The xlrd python module for reading spreadsheet documents - Introduction
  2. The xlrd python module for reading excel spreadsheets - Installation
  3. The xlrd python module for reading data in spreadsheets - Quickstart  

After you complete reading all these, go to the official documentation, you will for sure understand each and every function or method or class easily.

Finally, please don't hesitate to comment in the comment box below if I have made any mistake or you want me to add any topic. I will for sure reply to you as soon as possible and help you.

Thank you. Have a nice day!

Popular posts from this blog

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

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 tag Us

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