class get_xml():
  #加載獲取xml的文檔對象
  def __init__(self,address):
    #解析address文件，返回DOM對象，address為文件地址
    self.doc = minidom.parse(address)
    #DOM是樹形結(jié)構(gòu)，_get_documentElement()獲得了樹形結(jié)構(gòu)的根節(jié)點
    self.root = self.doc._get_documentElement()
    #.getElementsByTagName()，根據(jù)name查找根目錄下的子節(jié)點
    self.httpSample_nodes = self.root.getElementsByTagName('httpSample')
  def getxmldata(self):
    data_list=[]
    j = -1
    responseData_node = self.root.getElementsByTagName("responseData")
    for i in self.httpSample_nodes:
      j = j+1
      #getAttribute()，獲取DOM節(jié)點的屬性的值
      if i.getAttribute("lb") == "發(fā)送信息":
        a = 'chatId":"(.*?)"'
      elif i.getAttribute("lb") == "接收信息":
        # a = "chatId%3A%22(.*?)%22"
        a = "info%3A%22(.*?)%22"
      if (i.getAttribute("lb") == "發(fā)送信息" or i.getAttribute("lb") == "接收信息") and i.getAttribute("rc") == "200":
        try:
          #使用re包里面的方法，通過正則表達式提取數(shù)據(jù)
          b = re.search(a, responseData_node[j].firstChild.data)
          if b is not None:
            d = b.group(1)
            print("d:",d)
            data_list.append((d, i.getAttribute("ts"), i.getAttribute("lt"),i.getAttribute("lb")))
        except:
          pass
    return data_list

import openpyxl
from openpyxl import writer,load_workbook
# Workbook用來在內(nèi)存里創(chuàng)建文件最后寫進磁盤的
from openpyxl.workbook import workbook, Workbook
from openpyxl.writer.excel import ExcelWriter
from openpyxl.cell import get_column_letter
# if __name__ == "__main__":
def importexcel(match,dest_filename):
  if(os.path.exists(dest_filename)):
    wb = load_workbook(filename=dest_filename)
  else:
    wb = Workbook()
  ew = ExcelWriter(workbook = wb)
  #創(chuàng)建一個新sheet
  wb.create_sheet(0, '聊聊發(fā)送接收請求')
  # 打開已存在的第一個sheet，也可以用get_sheet_names獲得所有的sheet的名字
  ws = wb.worksheets[0]
  ws.title = "聊聊發(fā)送接收請求"
  ws.cell('A1').value = "chartid"
  ws.cell('B1').value = "接收時間戳"
  ws.cell('C1').value = "發(fā)送時間戳"
  ws.cell('D1').value = "時間戳差"
  ws.cell('E1').value = "接收lt"
  ws.cell('F1').value = "發(fā)送到接收的響應(yīng)時間"
  l = 2
  for i in match:
    ws.cell(row=l,column=1).value = i['chatId']
    ws.cell(row=l,column=2).value = i['accept_timestamp']
    ws.cell(row=l,column=3).value = i['send_timestamp']
    ws.cell(row=l,column=4).value = i['timestamp_gap']
    ws.cell(row=l,column=5).value = i['accept_lt']
    ws.cell(row=l,column=6).value = i['response_time']
    print(i,l)
    l = l+1
  ew.save(filename = dest_filename)