Data2017.py 文件源码

def handle_excel():   #??excel?????
    dataall = xlrd.open_workbook(file_path)
    dataall.sheet_names()
    sheetzb_name = dataall.sheet_names()[0]
    sheetzb = dataall.sheet_by_name(sheetzb_name)
    f = xlwt.Workbook()  # ?????
    sheet1 = f.add_sheet(u'sheet1', cell_overwrite_ok=True)  # ??sheet
    style = xlwt.XFStyle()  # ?????
    style.alignment.wrap = 1
    row0 = [u'????', u'????', u'????', u'???', u'??',u'??', u'?????',u'?????', u'???',u'?????']
    # ?????
    for x in range(len(row0)):
        sheet1.write(0, x, row0[x], set_style('Times New Roman', 200, True))

    for i in range(sheetzb.nrows):
        for j in range(sheetzb.ncols):
            match=re.search(pattern,str(sheetzb.cell(i,5).value))
            if match:
                    sheet1.write(i,0,sheetzb.cell(i,0).value)
                    sheet1.write(i,1,sheetzb.cell(i,1).value)
                    sheet1.write(i,2,sheetzb.cell(i,2).value)
                    sheet1.write(i,3,sheetzb.cell(i,3).value)
                    sheet1.write(i,4,sheetzb.cell(i,4).value)
                    sheet1.write(i,5,sheetzb.cell(i,5).value)
                    sheet1.write(i,6,sheetzb.cell(i,6).value)
                    sheet1.write(i,7,sheetzb.cell(i,7).value)
                    sheet1.write(i,8,sheetzb.cell(i,8).value)
                    sheet1.write(i,9,sheetzb.cell(i,9).value)
    f.save('Data2017.xls')