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

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.
Read more

Project Euler Problem 66 Solution with python

Diophantine equation ¶ Consider quadratic Diophantine equations of the form: $$ x^{2} – Dy^{2} = 1 $$ For example, when $D = 13$, the minimal solution in $ x $ is $ 649^{2} – 13 \times 180^{2} = 1 $ It can be assumed that there are no solutions in positive integers when $ D $ is square. By finding minimal solutions in $ x $ for $ D = {2, 3, 5, 6, 7} $, we obtain the following: $$ 3^{2} – 2×2^{2} = 1 $$ $$ 2^{2} – 3×1^{2} = 1 $$ $$ 9^{2} – 5×4^{2} = 1 $$ $$ 5^{2} – 6×2^{2} = 1 $$ $$ 8^{2} – 7×3^{2} = 1 $$ Hence, by considering minimal solutions in $ x $ for $ D ≤ 7 $, the largest $ x $ is obtained when $ D = 5 $. Find the value of $ D ≤ 1000 $ in minimal solutions of $ x $ for which the largest value of $ x $ is obtained.
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