[Python] 纯文本查看 复制代码#!/usr/bin/env python
# -*- coding: UTF-8 -*-
#
# generated by wxGlade 0.9.5 on Wed May 13 20:53:38 2020
#
import wx
import pandas as pd
# begin wxGlade: dependencies
# end wxGlade
# begin wxGlade: extracode
# end wxGlade
class MyFrame(wx.Frame):
def __init__(self, *args, **kwds):
# begin wxGlade: MyFrame.__init__
kwds["style"] = kwds.get("style", 0) | wx.DEFAULT_FRAME_STYLE
wx.Frame.__init__(self, *args, **kwds)
self.SetSize((400, 300))
self.fn = wx.TextCtrl(self, wx.ID_ANY, "")
self.tn = wx.TextCtrl(self, wx.ID_ANY, "")
self.inp = wx.Button(self, wx.ID_ANY, u"录入")
self.oup = wx.Button(self, wx.ID_ANY, u"导出")
self.ex = wx.Button(self, wx.ID_ANY, u"退出")
#---------------button----------------------
self.inp.Bind(wx.EVT_BUTTON,self.inp_e)
self.oup.Bind(wx.EVT_BUTTON,self.oup_e)
self.ex.Bind(wx.EVT_BUTTON,self.ex_e)
#------------------tex--------------------------
self.fn.Bind(wx.EVT_TEXT,self.fn_e)
self.tn.Bind(wx.EVT_TEXT,self.tn_e)
#---------------------bl-------------------------
self.tn_n=''
self.fn_n=''
self.dic={'fn':[],'tn':[]}
self.__set_properties()
self.__do_layout()
# end wxGlade
def fn_e(self,event):
self.fn_n=self.fn.GetValue()
def tn_e(self,event):
self.tn_n=self.tn.GetValue()
def inp_e(self,event):
if self.fn_n!='' and self.tn_n!='':
self.dic['fn'].append(self.fn_n)
self.dic['tn'].append(self.tn_n)
self.fn.Clear()
self.tn.Clear()
else:
wx.MessageBox('录入信息不完整')
def oup_e(self,event):
out=pd.DataFrame(self.dic)
out.to_excel('result.xlsx')
wx.MessageBox('导出完成')
def ex_e(self,event):
wx.Exit()
def __set_properties(self):
# begin wxGlade: MyFrame.__set_properties
self.SetTitle("frame")
self.fn.SetMinSize((300, 22))
self.tn.SetMinSize((300, 22))
# end wxGlade
def __do_layout(self):
# begin wxGlade: MyFrame.__do_layout
sizer_1 = wx.BoxSizer(wx.VERTICAL)
grid_sizer_1 = wx.GridSizer(3, 1, 0, 0)
grid_sizer_2 = wx.GridSizer(1, 3, 0, 0)
sizer_3 = wx.BoxSizer(wx.HORIZONTAL)
sizer_2 = wx.BoxSizer(wx.HORIZONTAL)
label_1 = wx.StaticText(self, wx.ID_ANY, "Family Name")
label_1.SetMinSize((100, 17))
sizer_2.Add(label_1, 0, wx.ALIGN_CENTER, 0)
sizer_2.Add(self.fn, 0, wx.ALIGN_CENTER, 0)
grid_sizer_1.Add(sizer_2, 1, wx.EXPAND, 0)
label_2 = wx.StaticText(self, wx.ID_ANY, "Trade Name")
label_2.SetMinSize((100, 17))
sizer_3.Add(label_2, 0, 0, 0)
sizer_3.Add(self.tn, 0, 0, 0)
grid_sizer_1.Add(sizer_3, 1, wx.EXPAND, 0)
grid_sizer_2.Add(self.inp, 0, wx.ALIGN_CENTER, 0)
grid_sizer_2.Add(self.oup, 0, wx.ALIGN_CENTER, 0)
grid_sizer_2.Add(self.ex, 0, wx.ALIGN_CENTER, 0)
grid_sizer_1.Add(grid_sizer_2, 1, wx.EXPAND, 0)
sizer_1.Add(grid_sizer_1, 1, wx.EXPAND, 0)
self.SetSizer(sizer_1)
self.Layout()
# end wxGlade
# end of class MyFrame
class MyApp(wx.App):
def OnInit(self):
self.luru = MyFrame(None, wx.ID_ANY, "")
self.SetTopWindow(self.luru)
self.luru.Show()
return True
# end of class MyApp
if __name__ == "__main__":
app = MyApp(0)
app.MainLoop()