Python数据分析入门--xml关键字数据输出到xlsx

xml通过关键字搜索传输数据到xlsx

import csv
import pandas as pd
import xlwt
import xlsxwriter
import xlrd

def read_xml_file_gt():
    find_keywor1 = 0
    keyword_list1 = []
    keyword1 = "Time"
    xml_file = open('***.xml')
    for line in xml_file:
        if line.find(keyword1) != -1 and find_keywor1 == 0:
            find_keywor1 = 1
            text_list = line.split("=")
            i = 2
            while i < (len(text_list) - 2):
                keyword_list1.append(text_list[i].split(" ")[-1])
                keyword_list.append(text_list[i].split(" ")[-1])
                i = i + 1
      value_lists1 = [[] for i in range(list_num1 + 1)]
          j = 0
    while j < list_num1:
        xml_file = open('***.xml')
        #print keyword_list1[j]
        for line in xml_file:
            if line.find(keyword_list1[j]) != -1: #find keyword data
                text_list = line.split(" ")
                value_list = text_list[j + 3].split("\"")
                value_lists1[j + 1].append(value_list[1])
        j = j + 1
    workbook = xlsxwriter.Workbook('yyy.xlsx')
    worksheet0 = workbook.add_worksheet('Output')
    key_list_out = ['PositionQ','PositionX','PositionY','dPositionZ']
    worksheet0.write_row('D1',key_list_out)  
    worksheet0.write_column('D2',value_lists2[6])
    worksheet0.write_column('E2',value_lists2[3])
    worksheet0.write_column('F2',value_lists2[4])
    worksheet0.write_column('G2',value_lists2[5])
    workbook.close()

千万别忘了workbook.close()，否则保存不到xlsx中