Read rows and columns by Python, by excel

Question

My doubt is if there is any resource for me to be able to read excel rows and columns. For example: I have experimental data in excel containing header in the first row having about 12 columns of data, so [1:12] would be just the header, and about 30 rows of numerical data, I wanted to know exactly that, as it takes only of the data within that matrix, and then select each column and form a list?

Answer 1

Yes, there is the package xlrd who reads Excel files for you.

Example:

import xlrd
book = xlrd.open_workbook("meuarquivo.xls")
print "Número de abas: ", book.nsheets
print "Nomes das Planilhas:", book.sheet_names()
sh = book.sheet_by_index(0)
print(sh.name, sh.nrows, sh.ncols)
print("Valor da célula D30 é ", sh.cell_value(rowx=29, colx=3))
for rx in range(sh.nrows):
    print(sh.row(rx))

I took the example from here.

See also this site.