excel_reader.py

import xlrd
import time
from tkinter.filedialog import askopenfilename

def open_file():                            # KEEP FOR TOPLEVEL SCRIPT
    file_name = askopenfilename()
    print(file_name)
    return file_name

def split_adress(adress):
    split_up = adress.split(", ")
    if split_up == ['']:
        split_up.append('')
    return split_up

def read_excel(dossier=None):
    print("start reading excel \n dossier: \n {}".format(dossier))
    book = xlrd.open_workbook(dossier)
    first_sheet = book.sheet_by_index(0)                                # get first worksheet
    #create dict
    werf_adress = split_adress(first_sheet.cell(3,2).value)
    w_adress = split_adress(first_sheet.cell(13,2).value)
    arch_adress = split_adress(first_sheet.cell(14,2).value)
    aa_adress = split_adress(first_sheet.cell(25,2).value)
    label_dict = {
        "woning straat": werf_adress[0],
        "woning gemeente": werf_adress[1],
        "bouwheer": first_sheet.cell(13,1).value,
        "werfadres": w_adress[0],
        "werfgemeente": w_adress[1],
        "architect": first_sheet.cell(14,1).value,
        "architect straat": arch_adress[0],
        "architect gemeente": arch_adress[1],
        "architect gsm": first_sheet.cell(14,3).value,
        "architect email": first_sheet.cell(14,6).value,
        "aannemer": first_sheet.cell(25,1).value,
        "aannemer straat": aa_adress[0],
        "aannemer gemeente": aa_adress[1],
        "ingenieur": "ingenieur"
        }
    print("extracted data: \n {}".format(label_dict))
    return label_dict