windows - PyQt QFileDialog getOpenFileName从命令行不起作用(Windows)

我试图创建一个gui（qt设计器）来导入一个excel文件并在gui中显示数据。
当我在ide（spyder）中运行脚本时，它工作得很好，但是如果我从命令窗口运行它，或者从windows资源管理器打开python文件，则导入函数不工作。（gui可以正常启动，但是当按下导入按钮并选择文件时，不会发生任何事情，也不会产生任何错误。从Spyder运行时，数据将按预期导入并显示在图形用户界面中）。
如果我预先选择了文件位置（在下面的代码中注释掉了），则脚本可以从命令行或通过单击资源管理器正常工作。
谢谢你的帮助！
蟒蛇2.7（蟒蛇），Windows 10，pyqt4

import sys
from PyQt4 import QtGui
from excel_import_gui import Ui_MainWindow
import xlrd


class Main(QtGui.QMainWindow):
    def __init__(self):
        QtGui.QMainWindow.__init__(self)
        self.ui = Ui_MainWindow()
        self.ui.setupUi(self)

        self.setupSignals()


    def set_import_data(self,data_to_import,table_to_change):
        for row in range(len(data_to_import)):
            for col in range(len(data_to_import[0])):
                table_to_change.setRowCount(len(data_to_import))
                table_to_change.setColumnCount(len(data_to_import[0]))
                item = data_to_import[row][col]
                table_to_change.setItem(row,col,QtGui.QTableWidgetItem(str(item)))


    def setupSignals(self):
        self.ui.importData_btn.clicked.connect(self.select_file)


    def select_file(self):
        excel_file = QtGui.QFileDialog.getOpenFileName(self,
        "Select Excel file to import","","Excel (*.xls *.xlsx)")

#        excel_file = "C:/Users/Ben/Work/Python tests/Qt GUIs/Excel_import_GUI/fish_test.xlsx"


        if excel_file:
            open_excel_file = xlrd.open_workbook(excel_file)
            self.start_import_data(open_excel_file)


    def start_import_data(self, workbook):
        #import data from excel file
        workbook_data = []
        for sheetNum in range (workbook.nsheets):
            worksheet = workbook.sheet_by_index(sheetNum)
            workbook_data.append([[worksheet.cell_value(row,col) for col in range (worksheet.ncols)] for row in range(worksheet.nrows)])

        # Set each worksheet of workbook_data to each tab in GUI widget
        self.set_import_data(workbook_data[0],self.ui.fish_table)
        self.set_import_data(workbook_data[1],self.ui.boats_table)


if __name__ == "__main__":
    app = QtGui.QApplication(sys.argv)
    window = Main()
    window.show()
    sys.exit(app.exec_())

最佳答案

我自己通过将excel_文件变量转换成字符串找到了一个解决方案。

excel_file = str(QtGui.QFileDialog.getOpenFileName(self, "Select Excel file to import","","Excel (*.xls *.xlsx)"))