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"])