python读取excle实现替换序号

使用openpyxl可以读取xlsx格式excle文件，以下为简单实例实现替换excle中序号

import openpyxl
data = openpyxl.open('C:\\Users\\root\\Desktop\\1.xlsx')
sheet = data.active
print(sheet.title)


def work_data(start,end,num):
    try:
        for hang in range(start, end+1):
            result = sheet.cell(hang,1).value
            if "、" in result:
                s = result.split("、")
                value = str(num)+"、"+s[1]
                sheet.cell(hang,1,value=value)
                num += 1
    except Exception as e:
        print(e)


num = 1 
start = 1 #起始行
end = 34 #结束行
work_data(start,end,num)
data.save("C:\\Users\\root\\Desktop\\2.xlsx")