python 处理excel表格

from openpyxl import load_workbook
from openpyxl import Workbook
import os
import os.path as osp

xml = '0.xlsx'

def read_xls(name):
    wb_r = load_workbook(osp.join("G:\\DATESETS\\VOCdevkit\\FINGER\\Annotations", name ) )
    sheet = wb_r['Sheet1']
    return sheet



def save_xls(name,sheet):
    rows_num = len(sheet["A"])
    cols = sheet["1"]
    wb_w = Workbook()
    sheet1 = wb_w.active

    for row in range(1,rows_num):
        #print(row.column_letter)#column_letter
        for col in cols:
            #print(row.column_letter + str(col + 1))
            #sheet[col.column_letter + str(row + 1)
            if sheet[col.column_letter + '1'].value == 'filename':
                print(sheet[col.column_letter + '1'].value)
                if row == 1:
                    sheet1[col.column_letter + str(row)].value = sheet[col.column_letter + str(row)].value
                    print(sheet1[col.column_letter + str(row)].value)
                else:
                    filename_str = sheet[col.column_letter + str(row)].value
                    image_name = filename_str.split('.')
                    sheet1[col.column_letter + str(row )] = str(int(image_name[0]) + int(name)) + image_name[1]
                    print(sheet1[col.column_letter + str(row)].value)
            else:
                #print(sheet[col.column_letter + str(row + 1)].value)
                sheet1[col.column_letter + str(row)] = sheet[col.column_letter + str(row)].value
                #print(sheet1[col.column_letter + str(row + 1)])
    print(osp.join("G:\\DATESETS\\VOCdevkit\\FINGER\\Annotations", str(name) + '.xlsx'), "  Save Success!")
    wb_w.save(osp.join("G:\\DATESETS\\VOCdevkit\\FINGER\\Annotations", str(name) + '.xlsx' ) )



if __name__ == '__main__':
    sheet = read_xls(xml)
    for i in range(1,12):
        save_xls(i,sheet)

    print('Finish Fake Annotations!')