python 写 excel文件

python写excel文件的链接都是从这里获取的:

http://blog.csdn.net/longshen747/article/details/17194259

http://www.cnblogs.com/yanzhi123/archive/2012/04/16/2452214.html

 

上个示例的代码:

import xml.etree.ElementTree as ET
import xlwt
import os

path = "D:/Cai_Bishe/xml/"
print path

wb = xlwt.Workbook()

for root, dirs, list in os.walk(path):
for l in list:
print l
dir = os.path.join(root, l)
wifiXml=ET.parse(dir)
wifiInfo=wifiXml.findall('./wifiInformation')
ws = wb.add_sheet(l)

i = 0
j = 0

for oneIter in wifiInfo:

for wifiList in oneIter.getchildren():
for wifi in wifiList.getchildren():
ws.write(i, j, wifi.tag)
j += 1
ws.write(i, j, wifi.text)
i += 1
j = 0

print wifi.tag, ':', wifi.text

print '############'

wb.save('info.xls')