在python wx.ListCtrl中粘贴excel数据

import wx
import pandas as pd

class MyFrame(wx.Frame):
    def __init__(self):
        wx.Frame.__init__(self, None, -1, "Excel数据粘贴到wx.ListCtrl", size=(600, 400))
        
        # 创建wx.ListCtrl控件
        self.list_ctrl = wx.ListCtrl(self, style=wx.LC_REPORT|wx.BORDER_SUNKEN)
        
        # 为wx.ListCtrl添加列
        self.list_ctrl.InsertColumn(0, '列1')
        self.list_ctrl.InsertColumn(1, '列2')
        self.list_ctrl.InsertColumn(2, '列3')
        
        # 创建一个按钮，用于触发粘贴操作
        button = wx.Button(self, label='粘贴')
        
        # 将按钮与粘贴函数绑定
        self.Bind(wx.EVT_BUTTON, self.on_paste, button)
        
        # 使用wx.BoxSizer布局管理器布局窗口
        sizer = wx.BoxSizer(wx.VERTICAL)
        sizer.Add(self.list_ctrl, 1, wx.EXPAND)
        sizer.Add(button, 0, wx.ALIGN_CENTER)
        self.SetSizer(sizer)
        
    def on_paste(self, event):
        # 获取剪贴板内容
        clipboard_data = wx.TextDataObject()
        if wx.TheClipboard.Open():
            success = wx.TheClipboard.GetData(clipboard_data)
            wx.TheClipboard.Close()
        
        # 解析剪贴板内容，并将数据添加到wx.ListCtrl中
        if success:
            df = pd.read_clipboard(sep='\t')
            for i, row in df.iterrows():
                index = self.list_ctrl.InsertItem(self.list_ctrl.GetItemCount(), str(row[0]))
                self.list_ctrl.SetItem(index, 1, str(row[1]))
                self.list_ctrl.SetItem(index, 2, str(row[2]))

app = wx.App()
frame = MyFrame()
frame.Show()
app.MainLoop()