python 将列表使用filedialog保存到指定的excel文件中
def toExcel(self):
‘’’
导出列表到Excel文件中
:return:
‘’’
ftypes=[(‘Excel files’,’.xls’),(‘All files’,’*’)]
file_path=tk.filedialog.asksaveasfilename(title=‘保存文件’,filetypes=ftypes,defaultextension=’.xls’)
data=self.list
print(“file_path:”+ file_path)
if file_path !=’’:
with open(file_path,‘w’,encoding=‘GBK’) as result:
if result is not None:
result.write(‘id\t姓名\t性别\t年龄\t职称\n’)
for i in range(len(data)):
for j in range(len(data[i])):
result.write(str(data[i][j]))
result.write(’\t’)
result.write(’\n’)
result.close()
tkinter.messagebox.showinfo(“保存”,“保存完成”)
else:pass