dataFrameViewer.py 文件源码

def writeExcelOutput(self,table):
        if isinstance(table,QTabWidget):
            filename = table.currentWidget().model()._filename
            writer = pd.ExcelWriter(filename, engine='xlsxwriter')

            for i in range(table.count()):
                data=table.widget(i)
                sheetname=table.tabText(i)
                data.model()._df.to_excel(writer, sheet_name=sheetname,index=False)
                data.model()._dirty = False
            writer.save()
        if isinstance(table,QTableView):
            filename = table.model()._filename
            writer = pd.ExcelWriter(filename, engine='xlsxwriter')
            table.model()._df.to_excel(writer, sheet_name='Sheet 1',index=False)
            table.model()._dirty = False
            writer.save()