def openFile(self): s = QFileDialog.getOpenFileName(self,"Open file dialog","/","Excel files(*.xls)") if not s == "": if self.sender().text() == "Select Source": self.sourcePathEdit.setText(str(s)) self.sourceSheetBox.clear() sourceExcel = ExcelApp(s,"") self.sourceSheetBox.addItems(sourceExcel.getSheetsName()) elif self.sender().text() == "Select Target": self.targetPathEdit.setText(str(s)) self.targetSheetBox.clear() targetExcel = ExcelApp(s,"") self.targetSheetBox.addItems(targetExcel.getSheetsName())