import xlrd book = xlrd.open_workbook('ex.xls') shx = book.sheet_by_index(0) for c in range(shx.ncols): for r in range(shx.nrows): print (shx.cell(r, c).value)