|
#!/usr/bin/env python
# -*- coding: UTF-8 -*-
# This script use to get the data from XML file and then put this data in a excel.
from xml.dom import minidom
from pyExcelerator import *
import sys
import os
import datetime
import time
def getTagText(root,tag,current_time):
Allnodes=root.getElementsByTagName(tag)
w=Workbook()
ws=w.add_sheet(current_time)
row,col=1,1
for nodes in Allnodes:
for node in nodes.childNodes:
if node.nodeType != node.TEXT_NODE:
#print node
#print node.childNodes[0].data
s=node.childNodes[0].data
ws.write(row,col,s)
col+=1 #next col
# Reset next row
row+=1
col=1
w.save('F:\\python\\xmldata\\'+current_time+'.xls')
#Format the time as 'YYmmddHHMMSS'
def format_time():
x=time.localtime()
t=datetime.datetime(*x[:6])
return t.strftime("%Y%m%d%H%M%S")
if __name__=='__main__':
#path=sys.arv[1]
path="F:\\Python\\test.xml"
root=minidom.parse(path)
tag='ExchangeRate'
current_time=format_time()
getTagText(root,tag,current_time)
|
