def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
workbook_to_lua(workbook, sheet, filename)
#workbook_multi_key_to_lua(workbook, ur"配件ID和属性", "adjunct_hero", ["hero_id", "position", "adjunct"], False, ["quality_level"])
workbook_multi_key_to_lua(workbook, ur"英雄配件绑定", "adjunct_hero", ["hero_id", "position"], False)
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
print(filename)
workbook_to_lua(workbook, sheet, filename)
workbook_suit_to_lua(workbook, ur"战队技能等级升级", ur"role_skill_up_cost")
def __call__(self, func):
work_book = load_excel(self.excel_file)
@load_sheel(work_book, self.excel_sheet)
def content_line_parser(content=0):
self.line_index = self.line_index + 1
# 扫描除去标题行的第一行 生成字段名和类型字典
if self.line_index == 1:
(self.field_count, self.field_name_dict, self.field_type_dict,
self.field_for_dict) = scan_get_name_type_arr(content)
return []
# 第1列为空 则整个EXCEL结束
if self.is_finish == 1 or content[0] == None:
self.is_finish = 1
return []
# 解析一个数据行
# ED - erlang name-value字典
# XD - xml name-value字典
(ED, XD) = scan_get_value_arr(content, self.field_count,
self.field_name_dict,
self.field_type_dict,
self.field_for_dict)
# 转换处理
func(ED, XD)
return []
content_line_parser()
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
print(filename)
workbook_to_lua(workbook, sheet, filename)
workbook_suit_to_lua(workbook, ur"洗练属性", ur"precious_smelt_attr")
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
workbook_multi_key_to_lua(workbook, ur"建筑对应图纸", ur"buildproduce_type",
["buildingId", "order"])
workbook_multi_key_to_lua(workbook, ur"建筑对应图纸", ur"buildproduce_index",
["id"])
for sheet, filename in sheet2luas.iteritems():
workbook_to_lua(workbook, sheet, filename)
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
print(filename)
workbook_to_lua(workbook, sheet, filename)
workbook_attr_to_lua(workbook, ur"属性配置", ur"rune_attr")
workbook_suit_to_lua(workbook, ur"套装属性", ur"rune_suit")
def excel_to_lua(excelname, sheetnames, lua_file_name):
workbook = load_excel(excelname)
data_cfg = []
data_str = "return {"
for sheet in sheetnames:
str = workbook_to_lua(workbook, sheet)
data_str = data_str + str
data_str = data_str + "}"
data_cfg.append(data_str)
gen_lua(lua_file_name, data_cfg)
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
p = workbook_to_lua(workbook, sheet, filename)
if filename == "eqm_suit":
os.system("lua eqm.lua \"%s\" eqm_suit_index.lua" % (p))
two_index_dict = {ur"装备提星消耗": ur"eqm_star"}
for sheet, filename in two_index_dict.iteritems():
workbook_suit_to_lua(workbook, sheet, filename, 2)
workbook_array_to_lua(workbook, "强化消耗和强化上限", "eqm_cfg")
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
workbook_to_lua(workbook, sheet, filename)
workbook_suit_to_lua(workbook, ur"英雄获得配置", "inst_up", 2)
workbook_array_to_lua(workbook, ur"共享数据", "inst_common")
workbook_multi_key_to_lua(workbook, ur"英雄编制扩充", ur"inst_hero_max_num",
["hero_id", "max_num"])
workbook_multi_key_to_lua(workbook, ur"英雄生产", ur"inst_produce_hero",
["hero_id", "hero_num"])
workbook_multi_key_to_lua(workbook, ur"建筑解锁英雄", ur"inst_unlock_hero",
["id", "level"])
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
workbook_to_lua(workbook, sheet, filename)
workbook_multi_key_to_lua(workbook, ur"英雄军衔配置表", ur"hero_quality",
['quality', 'hero_id'])
workbook_multi_key_to_lua(workbook, ur"星级属性", ur"hero_star_attr",
['id', 'star'])
workbook_one_kv_to_lua(workbook, ur"星级经验", ur"hero_star_exp", 'star',
'exp')
workbook_array_to_lua(workbook, ur"星级消耗物品", ur"hero_star_cfg")
workbook_multi_key_to_lua(workbook, ur"精英", ur"hero_quality_elite",
['hero_id', 'eliteLevel'])
def __call__(self, func):
work_book = load_excel(self.excel_file)
@load_sheel(work_book, self.excel_sheet)
def content_line_parser(content=0):
self.line_index = self.line_index + 1
# 扫描除去标题行的第一行 生成字段名和类型字典
if self.line_index == 1:
(self.field_count, self.field_name_dict, self.field_type_dict,
self.field_for_dict) = scan_get_name_type_arr(content)
return []
# 如已扫描结束 直接return
if self.is_finish == 1:
return []
if content[0] != None:
# 第1列不为空
# 解析
if len(self.sum_content) != 0:
# ED - erlang name-value字典
# XD - xml name-value字典
(ED, XD) = scan_get_value_arr(self.sum_content,
self.field_count,
self.field_name_dict,
self.field_type_dict,
self.field_for_dict)
func(ED, XD)
# 开始新累计
for i in range(0, self.field_count):
self.sum_content[i] = ("" if content[i] == None else str(
content[i]).strip())
# 特殊标记，如果是[END]，则sheet结束
if content[0] == "[END]":
self.is_finish = 1
else:
# 第1列为空，继续累计
for i in range(0, self.field_count):
if content[i] != None and str(content[i]).strip() != "":
self.sum_content[i] = self.sum_content[i] + "\n" + str(
content[i]).strip()
return []
content_line_parser()
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
workbook_to_lua(workbook, sheet, filename)
workbook_suit_to_lua(workbook, ur"洗练属性", ur"leader_smelt_attr", 2)
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
workbook_to_lua(workbook, sheet, filename)
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
workbook_to_lua(workbook, sheet, filename)
workbook_multi_key_to_lua(workbook, u"Sheet1", u"aide", ['id', 'pos'])
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
#for sheet, filename in sheet2luas.iteritems():
# workbook_to_lua(workbook, sheet, filename)
workbook_multi_key_to_lua(workbook, ur"商店配置表", ur"shop",
["shopID", "position"])
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
for sheet, filename in sheet2luas.iteritems():
workbook_to_lua(workbook, sheet, filename)
workbook_multi_key_to_lua(workbook, ur"物品合成配置", "item_com", ["type", "id"],
True)
def excel_to_lua(excelname):
workbook = load_excel(excelname)
workbook_attr_to_lua(workbook, ur"Sheet1", ur"audio_resource")
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
workbook_basic_to_lua(workbook, '世界boss基础配置表', 'wboss_system')
for sheet, filename in sheet2luas.iteritems():
workbook_to_lua(workbook, sheet, filename)
def excel_to_lua(excelname, sheet2luas):
workbook = load_excel(excelname)
workbook_multi_key_to_lua(workbook, ur"提示配置", ur"tips", ["needLv", "id"])
