python 文本替换

import xlrd
import xlwt
import re

workbook = xlwt.Workbook(encoding='ascii')
worksheet = workbook.add_sheet('text')

f = open(r"C:\Users\Martin\Desktop\a.lua", 'r+', encoding='UTF-8')
luaText = f.read()

k = -1


def replace(match):
    global k
    k = k + 1
    worksheet.write(k, 0, label='GameCodeIndex' + str(k))
    worksheet.write(k, 1, label=str(match.group())[1:-1])
    worksheet.write(k, 2, label='default')

    return 'GameCodeIndex' + str(k)


print(luaText)
luaText = re.sub("\"[^\"\n\r]*[\u4e00-\u9fa5]+[^\"\r\n]*\"", replace, luaText)

f.seek(0)
f.truncate()
f.write(luaText)
f.close()

workbook.save('Excel_workBook.xlsx')

 

import xlrd
import re

data = xlrd.open_workbook('Excel_workBook.xlsx')
table = data.sheets()[0]

data_list = []
for rx in range(0, table.nrows):
    temp_list = []
    index = table.cell(rx, 0).value
    ori = table.cell(rx, 1).value
    dest = table.cell(rx, 2).value
    temp_list = [index, ori, dest]
    data_list.append(temp_list)


# print(table.cell(0, 0).value)


def find_des_by_index(index):
    for value in data_list:
        # print(value[0], value[1], value[2])
        if str(value[0]) == str(index):
            if str(value[2]) != "default":
                return str(value[2])
            else:
                return str(value[1])

    return str(value[0])


f = open(r"C:\Users\Martin\Desktop\a.lua", 'r+', encoding='UTF-8')
luaText = f.read()


def replace_code(match):
    return find_des_by_index(match.group())


luaText = re.sub("GameCodeIndex\d+", replace_code, luaText)
f.seek(0)
f.truncate()
f.write(luaText)
f.close()