def select_file(self):
file_type = [('All Excel Files', '*.xlsx'),('All files', '*')]
dialog = tkFileDialog.Open(self, filetypes=file_type)
file1 = dialog.show()
occ_list = []
if file1 != '':
f = Fetch(file1, 'Sheet1')
f.get_data()
f.create_jobs()
self.occupation_dict = f.convert_data_to_dict()
for k in self.occupation_dict.keys():
occ_list.append(k)
self.my_cb['cb']['values'] = occ_list
self.my_cb['cb'].current(0)
self.my_cb['cb'].config(state='readonly')
