Python: read excel file

gistfile1

from xlrd import open_workbook


def is_row_hidden(sheet, row_n):
    try:
        if sheet.rowinfo_map[row_n].hidden:
            return True
    except KeyError:
        #  empty row, treat as hidden
        pass
    return False


def read_workbook(file_path, sheet_index=0):
    rb = open_workbook(file_path, formatting_info=True)
    r_sheet = rb.sheet_by_index(sheet_index)
    for row in range(r_sheet.nrows):
        for col in range(r_sheet.ncols):
            print r_sheet.cell_value(row, col)