dataFrameViewer.py 文件源码

def loadExcel(self,options):
        names = options['sheets']
        filename = options['file']
        openEach = options['openEach']
        df=pd.ExcelFile(filename)
        if not openEach:
            newTab = QTabWidget()
            newTab.setTabsClosable(True)
            newTab.currentChanged.connect(self.tabChanged)
            self.connect(newTab,SIGNAL("tabCloseRequested(int)"),
                         self.fileCloseInternalTab)
            for i in range(len(names)):
                table = QTableView()
                table.setAlternatingRowColors(True)
                model=DataFrameTableModel(filename=filename)
                model.trackDataChange.connect(self.trackChanges)
                table.setModel(model)
                ### Set some variables ###
                table.headers = table.horizontalHeader()
                table.vHeaders=table.verticalHeader()
                #### Set context menu for table headers ####
                table.headers.setContextMenuPolicy(Qt.CustomContextMenu)
                table.headers.customContextMenuRequested.connect(self.headerMenu)
                table.vHeaders.setContextMenuPolicy(Qt.CustomContextMenu)
                table.vHeaders.customContextMenuRequested.connect(self.vHeaderMenu)

                df2=df.parse(sheetname=names[i])
                model.setDataFrame(df2)
                newTab.addTab(table,names[i])
            newTab.setCurrentIndex(0)
            self.tableTabWidget.addTab(newTab,QFileInfo(filename).fileName())
            self.tableTabWidget.setCurrentWidget(newTab)
        else:
            for i in range(len(names)):
                table = QTableView()
                table.setAlternatingRowColors(True)
                model=DataFrameTableModel(filename=names[i])
                model.trackDataChange.connect(self.trackChanges)
                table.setModel(model)
                ### Set some variables ###
                table.headers = table.horizontalHeader()
                table.vHeaders=table.verticalHeader()
                #### Set context menu for table headers ####
                table.headers.setContextMenuPolicy(Qt.CustomContextMenu)
                table.headers.customContextMenuRequested.connect(self.headerMenu)
                table.vHeaders.setContextMenuPolicy(Qt.CustomContextMenu)
                table.vHeaders.customContextMenuRequested.connect(self.vHeaderMenu)
                df2=df.parse(sheetname=names[i])
                model.setDataFrame(df2)
                self.tableTabWidget.addTab(table,names[i])
                self.tableTabWidget.setCurrentWidget(table)