mtaobao.py 文件源码

def writeexcel(path, dealcontent):
    workbook = wx.Workbook(path)
    top = workbook.add_format(
        {'border': 1, 'align': 'center', 'bg_color': 'white', 'font_size': 11, 'font_name': '????'})
    red = workbook.add_format(
        {'font_color': 'white', 'border': 1, 'align': 'center', 'bg_color': '800000', 'font_size': 11,
         'font_name': '????', 'bold': True})
    image = workbook.add_format(
        {'border': 1, 'align': 'center', 'bg_color': 'white', 'font_size': 11, 'font_name': '????'})
    formatt = top
    formatt.set_align('vcenter')  # ?????????
    worksheet = workbook.add_worksheet()  # ?????????
    width = len(dealcontent[0])
    worksheet.set_column(0, width, 38.5)  # ???????22??
    for i in range(0, len(dealcontent)):
        if i == 0:
            formatt = red
        else:
            formatt = top
        for j in range(0, len(dealcontent[i])):
            if i != 0 and j == len(dealcontent[i]) - 1:
                if dealcontent[i][j] == '':
                    worksheet.write(i, j, ' ', formatt)
                else:
                    try:
                        worksheet.insert_image(i, j, dealcontent[i][j])
                    except:
                        worksheet.write(i, j, ' ', formatt)
            else:
                if dealcontent[i][j]:
                    worksheet.write(i, j, dealcontent[i][j].replace(' ', ''), formatt)
                else:
                    worksheet.write(i, j, '?', formatt)
    workbook.close()