import openpyxlfrom xmindparser import xmind_to_dictfrom openpyxl.styles import Alignmentdef xmind_xlxs():xmind_location = input(r"请输入完整的xmind文件地址,如F:\xmind\XXXX.xmind")try:d = xmind_to_dict(xmind_location)#读取xmind文件data = openpyxl.Workbook()data.create_sheet('Sheet1')table = data.activea = d[0]["topic"]table.column_dimensions['A'].width = 15 # 设置列宽table.column_dimensions['B'].width = 15table.column_dimensions['C'].width = 40table.column_dimensions['D'].width = 60table.column_dimensions['E'].width = 15table.column_dimensions['F'].width = 15head = a["title"] + ".xlsx" # 根据中心标题设置文件名称modules_len = len(a["topics"]) # 确认模块数量table.cell(1, 1, "大模块")table.cell(1, 2, "小模块")table.cell(1, 3, "用例标题")table.cell(1, 4, "操作步骤")table.cell(1, 5, "预期结果")table.cell(1, 6, "备注")row = 2 # 初始写入行数for i in range(modules_len): # 关于模块的循环modules = a["topics"][i]table.cell(row, 1, modules["title"]).alignment = Alignment(wrapText=True)try:condition_len = len(modules["topics"]) # 根据模块确认前提条件的数量except:row += 1continuefor n in range(condition_len): # 关于前提条件的循环condition = modules["topics"][n]table.cell(row, 2, condition["title"]).alignment = Alignment(wrapText=True)try:caption_len = len(condition["topics"]) # 根据前提条件确认用例标题的数量except:row += 1continuefor m in range(caption_len): # 关于用例标题的循环caption = condition["topics"][m]table.cell(row, 3, caption["title"]).alignment = Alignment(wrapText=True)try:operate_len = len(caption["topics"]) # 根据用例标题确定操作步骤的数量except:row += 1continuefor j in range(operate_len): # 关于操作步骤的循环operate = caption["topics"][j]table.cell(row, 4, operate["title"]).alignment = Alignment(wrapText=True)try:result_len=len(operate["topics"])except:row += 1continuefor k in range(result_len):# 关于结果的循环result=operate["topics"][k]table.cell(row, 5, result["title"]).alignment = Alignment(wrapText=True)try:remark_len=len(result["topics"])except:row += 1continuefor r in range(remark_len):#关于备注的循环remark = result["topics"][r]table.cell(row, 6, remark["title"]).alignment = Alignment(wrapText=True)row += 1data.save(head) # 保存文件except:print("您输入的文件地址有误")xmind_xlxs()if __name__ == '__main__':xmind_xlxs()
