我有一个默认的saveas函数绑定到一个按钮点击,它调用一个模式窗口。
另外,我还有一个函数,它将所需的数组保存为.xlsx文件。在self.data_processing.clicked.connect(self.process)
def process(self):
sample = pd.read_excel(self.fileName)
list_of_index = []
for i in range(len(sample.columns)):
sample2 = sample.iloc[:, lambda sample: [i]]
sample2 = sample2.columns[0]
list_of_index.append(sample2)
list_of_index
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
... ... Area where all the data is computed ... ... ...
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
workbook = xlsxwriter.Workbook('Sample.xlsx')
worksheet1 = workbook.add_worksheet()
worksheet2 = workbook.add_worksheet()
worksheet3 = workbook.add_worksheet()
worksheet4 = workbook.add_worksheet()
row = 0
for col, data in enumerate(fulllist):
worksheet1.write_column(row, col, data)
for col, data in enumerate(fulllist_percent):
worksheet2.write_column(row, col, data)
for col, data in enumerate(fulllist_click):
worksheet3.write_column(row, col, data)
for col, data in enumerate(additional_info):
worksheet4.write_column(row, col, data)
workbook.close()
基本上,我要问的是:如何在saveFile()中插入xlsx writer,以便使用默认的saveAs窗口将数组保存为xlsx
我的用户界面代码
^{pr2}$
我的主程序import os
import sys
import pandas as pd
im