本文实例为大家分享了wxPython电子表格功能的具体代码,供大家参考,具体内容如下
#!/usr/bin/env python
#encoding: utf8
import wx
import wx.grid as gridlib
#import wx.lib.mixins.grid as mixins
#---------------------------------------------------------------------------
class SimpleGrid(gridlib.Grid): ##, mixins.GridAutoEditMixin):
def __init__(self, parent, log):
gridlib.Grid.__init__(self, parent, -1)
##mixins.GridAutoEditMixin.__init__(self)
#打印log信息
self.log = log
self.moveTo = None
self.Bind(wx.EVT_IDLE, self.OnIdle)
#创建一个25X25的电子表格
self.CreateGrid(25, 25)#, gridlib.Grid.SelectRows)
##self.EnableEditing(False)
#simple cell formatting
#设置第index=3列的宽度大小,像素=200
self.SetColSize(col=3,width=200)
#设置第index=4行的高度大小,像素=45
self.SetRowSize(4, 45)
#设置 row=0,col=0,value="First cell"
self.SetCellValue(0, 0, "First cell")
#设置 row=1,col=1,value="Another cell"
self.SetCellValue(1, 1, "Another cell")
#设置 row=2,col=2,value="Yet another cell"
self.SetCellValue(2, 2, "Yet another cell")
#设置 row=3,col=3,value="This cell is read-only"
self.SetCellValue(3, 3, "This cell is read-only")
#设置字体格式
self.SetCellFont(0, 0, wx.Font(12, wx.FONTFAMILY_ROMAN, wx.FONTSTYLE_ITALIC, wx.FONTWEIGHT_NORMAL))
#设置字体颜色
self.SetCellTextColour(1, 1, wx.RED)
#设置cell背景颜色
self.SetCellBackgroundColour(2, 2, wx.CYAN)
#设置只读属性
self.SetReadOnly(3, 3, True)
#设置 row=5,col=0,数字编辑器
self.SetCellEditor(5, 0, gridlib.GridCellNumberEditor(1,1000))
#设置 row=5,col=0,value="123"
self.SetCellValue(5, 0, "123")
#设置 row=6,col=0,浮点数
self.SetCellEditor(6, 0, gridlib.GridCellFloatEditor())
#设置 row=6,col=0,value="123.34"
self.SetCellValue(6, 0, "123.34")
#设置
self.SetCellEditor(7, 0, gridlib.GridCellNumberEditor())
#设置 row=6,col=3,value="You can veto editing this cell"
<