python实现Xmind转换Excel工具

经常遇到问题：

• excel编写测试用例，评审时看的比较密集，使评审结果未能达到预期？
• xmind编写测试用例，逻辑清晰，可进行折叠展示，但公司要求excel？
• 如果有工具xmind格式转换excel就好？

那么，以下工具帮你解决上述问题，但需满足下面格式要求：

代码实现：
所需库：openpyxl、wxpython、xmindparser
xmind转化excel
实现可视化Gui

xmind转化excel
读取xmind数据

from xmindparser import xmind_to_dict
def readXmind( FileName):
   XmindContent = xmind_to_dict(FileName)[0]['topic']  # xmind内容
   print(XmindContent)

XmindFile = r'E:\桌面\用例模板.xmind'
readXmind(XmindFile)

用例层级数据处理

   rowNum = 1  # 计算测试用例的条数
   caseDict = {}   #用例数据

   FeaturesNUM = numberLen(XmindContent)  # 功能模块的数量  
   for i in range(FeaturesNUM):
       TestFeatures = numberLen(XmindContent['topics'][i])  # 第i个功能模块下，测试的功能点数量
       if TestFeatures != 0:
           for j in range(TestFeatures):
               TestPoints = numberLen(
                   XmindContent['topics'][i]['topics'][j])  # 第j个功能点里，有多少个测试点
               if TestPoints != 0:
                   for k in range(TestPoints):
                       TestTypes = numberLen(XmindContent['topics'][i]['topics'][j]['topics'][k])  # 第k个测试点里，有多少个测试项
                       if TestTypes != 0:
                           for m in range(TestTypes):
                               TestItems = numberLen(XmindContent['topics'][i]['topics'][j]['topics'][k]['topics'][m])  # 用例步骤
                               if TestItems != 0:
                                   for case in range(TestItems):
                                       caseDict['用例模块'] = XmindContent['topics'][i]['title']
                                       caseDict['用例标题'] = XmindContent['topics'][i]['topics'][j]['title'] + '/' + XmindContent['topics'][i]['topics'][j]['topics'][k]['title'] + '/' + XmindContent['topics'][i]['topics'][j]['topics'][k]['topics'][m]['title']  # 用例标题
                                       caseDict['用例步骤'] = XmindContent['topics'][i]['topics'][j]['topics'][k]['topics'][m]['topics'][case]['title']  # 用例步骤
                                       try:
                                           caseDict['预期结果'] = XmindContent['topics'][i]['topics'][j]['topics'][k]['topics'][m]['topics'][case]['topics'][0]['title']  # 用例预期结果
                                       except Exception as e:
                                           print(e)
                                       rowNum = rowNum + 1
                                       writeExcel(self.rowNum, self.caseDict) #写入excel

处理用例数

def numberLen(value):
   try:
       return len(value['topics'])
   except KeyError:
       return 0

excel文件处理

import openpyxl
class xmind_to_csv:
   def __init__(self,excelName):#文件名
       self.excelName=excelName
       self.filename = self.excelName + '.xlsx'
       self.workbook = openpyxl.Workbook()
       try:
           self.workbook.save(self.filename)
           self.workbook = openpyxl.load_workbook(self.filename)#打开文件
           self.worksheet = self.workbook.create_sheet(title=self.excelName, index=0)#创建sheet并命名
           del self.workbook['Sheet']
       except Exception:
           raise "文件已打开，请关闭重试"

写入excel表格处理

def numberLen(value):
   try:
       return len(value['topics'])
   except KeyError:
       return 0

可视化GUI处理(wx库)
页面实现

class MyFrame1(wx.Frame):

   def __init__(self, parent):
       wx.Frame.__init__(self, parent, id=wx.ID_ANY, title=u"Xmind转换Excel格式工具", pos=wx.DefaultPosition, size=wx.Size(345, 180),
                         style=wx.DEFAULT_FRAME_STYLE | wx.TAB_TRAVERSAL)

       self.SetSizeHints(wx.DefaultSize, wx.DefaultSize)

       bSizer1 = wx.BoxSizer(wx.VERTICAL)

       self.m_staticText1 = wx.StaticText(self, wx.ID_ANY, u"Xmind路径:", wx.DefaultPosition, wx.DefaultSize, 0)
       self.m_staticText1.Wrap(-1)

       self.m_staticText1.SetFont(
           wx.Font(12, wx.FONTFAMILY_DEFAULT, wx.FONTSTYLE_NORMAL, wx.FONTWEIGHT_BOLD, False, wx.EmptyString))
       self.m_staticText1.SetForegroundColour(wx.SystemSettings.GetColour(wx.SYS_COLOUR_BTNTEXT))

       bSizer1.Add(self.m_staticText1, 0, wx.ALL | wx.EXPAND, 5)

       self.m_filePicker4 = wx.FilePickerCtrl(self, wx.ID_ANY, wx.EmptyString, u"选择文件",
                                              u"xmind文件(*.xmind)|*.xmind", wx.DefaultPosition,
                                              wx.DefaultSize, wx.FLP_DEFAULT_STYLE | wx.FLP_FILE_MUST_EXIST,
                                              wx.DefaultValidator, u"浏览")
       bSizer1.Add(self.m_filePicker4, 0, wx.ALL | wx.EXPAND, 5)

       gSizer1 = wx.GridSizer(1, 2, 0, 0)

       gSizer1.SetMinSize(wx.Size(20, 20))
       self.m_button2 = wx.Button(self, wx.ID_ANY, u"确定", wx.DefaultPosition, wx.DefaultSize, 0)
       self.m_button2.SetBackgroundColour(wx.SystemSettings.GetColour(wx.SYS_COLOUR_INFOBK))

       gSizer1.Add(self.m_button2, 0, wx.ALL, 5)

       self.m_button1 = wx.Button(self, wx.ID_ANY, u"取消", wx.DefaultPosition, wx.DefaultSize, 0)
       self.m_button1.SetBackgroundColour(wx.SystemSettings.GetColour(wx.SYS_COLOUR_INFOBK))

       gSizer1.Add(self.m_button1, 0, wx.ALL | wx.ALIGN_RIGHT, 5)

       bSizer1.Add(gSizer1, 0, wx.EXPAND, 5)
       bSizer7 = wx.BoxSizer(wx.VERTICAL)


       self.m_staticText2 = wx.StaticText(self, wx.ID_ANY, u"工具人：Menghui Ding",
                                          wx.DefaultPosition, wx.Size(-1, 26), 0)
       self.m_staticText2.Wrap(-1)

       self.m_staticText2.SetBackgroundColour(wx.SystemSettings.GetColour(wx.SYS_COLOUR_HIGHLIGHT))

       bSizer7.Add(self.m_staticText2, 0, 0, 5)

       self.m_panel1 = wx.Panel(self, wx.ID_ANY, wx.DefaultPosition, wx.DefaultSize, wx.TAB_TRAVERSAL)
       bSizer7.Add(self.m_panel1, 1, wx.ALL | wx.EXPAND, 5)

       bSizer1.Add(bSizer7, 1, wx.EXPAND, 5)

       self.SetSizer(bSizer1)
       self.Layout()
       self.m_statusBar1 = self.CreateStatusBar(1, wx.STB_SIZEGRIP, wx.ID_ANY)

       # Connect Events

       self.m_button2.Bind(wx.EVT_BUTTON, self.m_button2OnButtonClick)
       self.m_button1.Bind(wx.EVT_BUTTON, self.m_button1OnButtonClick)

事件逻辑

   def __del__(self):
       pass

   def m_button1OnButtonClick(self, event):
       wx.Exit()

   def m_button2OnButtonClick(self, event):
       # 键盘控制
       # keyboard = Controller()
       # 获取文件路径
       XmindFile_path = self.m_filePicker4.GetPath()  # 获取当前选中文件的路径
       if "xmind" in XmindFile_path == 0:
           wx.MessageBox("路径错误", "提示",wx.ICON_ERROR)
       else:
           try:
               xmindFile = XmindFile_path.split("\\")[-1].split('.')[-2]
               xmind_to_csv(xmindFile).readXmind(XmindFile_path)
               wx.MessageBox("转换完成", "提示",wx.ICON_INFORMATION)
               wx.Exit()
           except Exception as erro:
               wx.MessageBox("请选择正确路径", "提示",wx.ICON_ERROR)
           event.Skip()
if __name__ == '__main__':
   app = wx.App(False)  # print输出是否重定向
   frame = MyFrame1(None)
   frame.Show()
   app.MainLoop()