wxFB

最新推荐文章于 2024-01-14 21:44:41 发布

lyric_chen

最新推荐文章于 2024-01-14 21:44:41 发布

阅读量454

点赞数 2

本文链接：https://blog.csdn.net/lyric_chen/article/details/90047092

版权

# -*- coding: UTF-8 -*-
import wx,os,sys,string
reload(sys)
sys.setdefaultencoding('utf-8')

class PageOne(wx.Panel):

def __init__(self, parent):

    def openFile(event):
        print self.m_filePicker1.GetTextCtrlValue()

    wx.Panel.__init__(self, parent)
    image_file = '1.jpg'
    to_bmp_image = wx.Image(image_file, wx.BITMAP_TYPE_ANY).ConvertToBitmap()
    self.bitmap = wx.StaticBitmap(self, -1, to_bmp_image, (0, 0))
    image_width = to_bmp_image.GetWidth()
image_height = to_bmp_image.GetHeight()
set_title = '%s %d x %d' % (image_file, to_bmp_image.GetWidth(), to_bmp_image.GetHeight())
#parent.SetTitle(set_title)
panel = wx.Panel(self)

bSizer1 = wx.BoxSizer(wx.VERTICAL)

self.m_filePicker1 = wx.FilePickerCtrl(self.bitmap, wx.ID_ANY, wx.EmptyString, u"Select a file", u"*.*",
                                       wx.DefaultPosition, wx.DefaultSize, wx.FLP_DEFAULT_STYLE)
bSizer1.Add(self.m_filePicker1, 0, wx.ALL, 5)

self.m_button1 = wx.Button(self.bitmap, wx.ID_ANY, u"文件导入", wx.DefaultPosition, wx.DefaultSize, 0)
self.m_button1.Bind(wx.EVT_BUTTON, openFile)
bSizer1.Add(self.m_button1, 0, 0, 50)

self.m_dirPicker1 = wx.DirPickerCtrl(self.bitmap, wx.ID_ANY, wx.EmptyString, u"Select a folder",
                                     wx.DefaultPosition, wx.DefaultSize, wx.DIRP_DEFAULT_STYLE)
bSizer1.Add(self.m_dirPicker1, 0, wx.ALL, 5)

self.m_button2 = wx.Button(self.bitmap, wx.ID_ANY, u"文件夹导入", wx.DefaultPosition, wx.DefaultSize, 0)
bSizer1.Add(self.m_button2, 0, wx.ALL, 5)

pic = wx.Image('button.bmp', wx.BITMAP_TYPE_BMP).ConvertToBitmap()  # 载入bmp图片
self.m_bpButton1 = wx.BitmapButton(self.bitmap, wx.ID_ANY, pic, wx.DefaultPosition, wx.DefaultSize,
                               wx.BU_AUTODRAW)
bSizer1.Add(self.m_bpButton1, 0, wx.ALIGN_CENTER_HORIZONTAL, 5)


self.SetSizer(bSizer1)
self.Layout()
bSizer1.Fit(self)
#self.m_filePicker1 = wx.FilePickerCtrl(self.bitmap, wx.ID_ANY, wx.EmptyString, u"Select a file", u"*.*", wx.DefaultPosition, wx.DefaultSize, wx.FLP_DEFAULT_STYLE)
#self.m_button1 = wx.Button(self.bitmap, wx.ID_ANY, u'文件导入', wx.Point( -1,-1 ), wx.DefaultSize, 0)
#self.m_dirPicker1 = wx.DirPickerCtrl(self.bitmap, wx.ID_ANY, wx.EmptyString, u"Select a folder",wx.DefaultPosition, wx.DefaultSize, wx.DIRP_DEFAULT_STYLE)
#self.m_button2 = wx.Button(self.bitmap, wx.ID_ANY, u'Dir Import', wx.DefaultPosition, wx.DefaultSize, 0)

class PageTwo(wx.Panel):
     def __init__(self, parent):
         wx.Panel.__init__(self, parent)
         panel = wx.Panel(self)
         colour = [(160,255,204),(153,204,255),(151,253,225),]
         self.SetBackgroundColour(colour[0])
         self.center = wx.StaticText(self, -1, u'ad', (355, 45),(100, -1), wx.ALIGN_CENTER)
         font = wx.Font(14, wx.SWISS, wx.NORMAL, wx.BOLD)
         self.center.SetFont(font)
class PageThree(wx.Panel):
     def __init__(self, parent):
         wx.Panel.__init__(self, parent)
         panel = wx.Panel(self)
         colour = [(160,255,204),(153,204,255),(151,253,225),]
         self.SetBackgroundColour(colour[0])
         self.center = wx.StaticText(self, -1, u'ac', (355, 45),(100, -1), wx.ALIGN_CENTER)
         font = wx.Font(14, wx.SWISS, wx.NORMAL, wx.BOLD)
         self.center.SetFont(font)

# -*- coding: utf-8 -*-

###########################################################################
## Python code generated with wxFormBuilder (version Jun  5 2014)
## http://www.wxformbuilder.org/
##
## PLEASE DO "NOT" EDIT THIS FILE!
###########################################################################

import wx,os,sys,string
import wx.lib.buttons
import wx.lib.buttons as buttons
from mypanel import PageOne
from mypanel import PageTwo
from mypanel import PageThree
reload(sys)
sys.setdefaultencoding('utf-8')

###########################################################################
## Author： Suvan
###########################################################################

class InFrame(wx.Frame):
    def __init__(self, parent, id):
        wx.Frame.__init__(self, parent, id, u'Excel处理工具', size=(800, 670), pos=(250, 70))
        menubar = wx.MenuBar()
        file = wx.Menu()
        file.Append(100, u'帮助', '')
        file.Append(101, u'退出', '')
        menubar.Append(file, u"&菜单")
        self.SetMenuBar(menubar)
        wx.EVT_MENU(self, 101, self.OnQuit)

        panel = wx.Panel(self)
        nb = wx.Notebook(panel, style=wx.NB_FIXEDWIDTH)

        page1 = PageOne(nb)
        page3 = PageThree(nb)
        page2 = PageTwo(nb)

        nb.AddPage(page1, u'文件导入')
        nb.AddPage(page2, u'文件操作')
        nb.AddPage(page3, u'格式转换')

        sizer = wx.BoxSizer()
        sizer.Add(nb, 1, wx.EXPAND)
        panel.SetSizer(sizer)
        page1.SetFocus()
        self.StatusBar()

    def StatusBar(self):
        self.statusbar = self.CreateStatusBar()

    def OnQuit(self, event):
        self.Close()

# -*- coding: utf-8 -*-
from openpyxl import Workbook
from openpyxl import load_workbook
from openpyxl.writer.excel import ExcelWriter
from datetime import date, datetime


def read_excel():
    # 打开文件
    wb = load_workbook('mainbuilding33.xlsx')
    # 获取所有sheet
    print wb.get_sheet_names()  # [u'sheet1', u'sheet2']
    a_sheet = wb.get_sheet_by_name('Sheet1')
    # 获得sheet名
    print(a_sheet.title)
    # 获得当前正在显示的sheet, 也可以用wb.get_active_sheet()
    sheet = wb.active

    # 根据sheet索引或者名称获取sheet内容
    sheet2 = wb.sheet_by_index(1)  # sheet索引从0开始
    sheet2 = wb.sheet_by_name('sheet2')

    # sheet的名称，行数，列数
    print sheet2.name, sheet2.nrows, sheet2.ncols

    # 获取整行和整列的值（数组）
    rows = sheet2.row_values(3)  # 获取第四行内容
    cols = sheet2.col_values(2)  # 获取第三列内容
    print rows
    print cols

    # 获取单元格内容
    print sheet2.cell(1, 0).value.encode('utf-8')
    print sheet2.cell_value(1, 0).encode('utf-8')
    print sheet2.row(1)[0].value.encode('utf-8')

    # 获取单元格内容的数据类型
    print sheet2.cell(1, 0).ctype


if __name__ == '__main__':
    read_excel()