from sqlalchemy import create_engine
import pandas as pd
import os
import MySQLdb

engine = create_engine('mysql+mysqldb://root:@localhost/myDB?
charset=utf8mb4&binary_prefix=true', echo=False)

mydir = (os.getcwd()).replace('\', '/') + '/'
all_data = pd.read_excel(r'' + mydir + 'Governance_Tracker - Copy -
Copy.xlsm'
,header = 1)#.drop(['#'], axis=1)
all_data.replace('n','', regex=True)
df = all_data.where((pd.notnull(all_data)), None)
print(df)
for i in range(len(df)):
data_dict ={}
data_dict['id'] = df['#'][i]
data_dict['site_name'] = df['Site Name'][i]
data_dict['region'] = df['Region'][i]
data_dict['site_type'] = df['Site Type'][i]
data_dict['site_code'] = df['SiteCode'][i]
data_dict['tac_name'] = df['TAC Name'][i]
data_dict['dt_readiness'] = df['DTnReadiness'][i]
data_dict['rfs'] = df['RFS'][i]
data_dict['rfs_date'] = df['RFS Date'][i]
df1 = pd.DataFrame(data_dict,index=[0])
df1.to_sql('govtracker', con=engine,if_exists='append',index=False)

print("Success")
rows = engine.execute("SELECT * FROM govtracker").fetchall()
print(rows)

import tkinter as tk
from tkinter import filedialog
import pandas as pd
import os
from sqlalchemy import create_engine
import MySQLdb

engine = create_engine('mysql+mysqldb://root:@localhost/myDB?
charset=utf8mb4&binary_prefix=true', echo=False)
mydir = (os.getcwd()).replace('\', '/') + '/'

root = tk.Tk()

canvas1 = tk.Canvas(root, width=300, height=300, bg='lightsteelblue')
canvas1.pack()


def getExcel():
global all_data

import_file_path = filedialog.askopenfilename()
all_data = pd.read_excel(import_file_path)
print(all_data)


browseButton_Excel = tk.Button(text='Import Excel File', command=getExcel,
bg='green', fg='white',
                           font=('helvetica', 12, 'bold'))
canvas1.create_window(150, 150, window=browseButton_Excel)

root.mainloop()