Read data from Excel

This example shows how to read data from an Excel file.

Note: Xlrd is for reading data and formatting information from older Excel files (ie: .xls)

import xlrd   # Open the workbook wb = xlrd.open_workbook('excel-xlrd-sample.xls')   # Print the sheet names print wb.sheet_names()   # Get the first sheet either by index or by name sh = wb.sheet_by_index(0)   # Iterate through rows, returning each as a list that you can index: for rownum in range(sh.nrows): print sh.row_values(rownum)   # If you just want the first column: first_column = sh.col_values(0) print first_column   # Index individual cells: cell_c4 = sh.cell(3, 2).value # Or you can use: #cell_c4 = sh.cell(rowx=3, colx=2).value print cell_c4   # Let's say you want the same cell from x identical sheets in a workbook: x = 2 while x >= 0: sh = wb.sheet_by_index(x) cell_x = sh.cell(2, 3).value print cell_x x = x - 1

You may use xlsxwriter to read the xlsx or the files generated by Excel 2010