1.編寫xml文件
2.使用Python的ElementTree模塊來解析XML
import xml.etree.ElementTree as ET
from openpyxl import Workbook# 解析XML函數
def parse_xml(xml_file):tree = ET.parse(xml_file)root = tree.getroot() --打開根節點data = []for user in root.findall('Users/User'):user_data = {'name': user.find('UserName').text,'code': user.find('UserCode').text,'password': user.find('UserPassword').text}data.append(user_data)return data?3.將數據寫入Excel函數
# 將數據寫入Excel函數
def write_to_excel(data, excel_file):# 創建Excel工作簿和工作表wb = Workbook()ws = wb.active# 設置標題行ws.append(['UserName', 'UserCode', 'UserPassword'])for user in data:ws.append([user['name'], user['code'], user['password']])wb.save(excel_file)
4.運行
# 主程序
if __name__ == '__main__':xml_file = 'user.xml' # 假設你的XML文件名為user.xmlexcel_file = 'users.xlsx'user_data = parse_xml(xml_file)write_to_excel(user_data, excel_file)
?
