#coding:utf-8data='''<?xmlversion ="1.0"encoding="utf-8"?>00221
#coding:utf-8
data ='''<?xml version="1.0" encoding="utf-8"?>
00221
asdfasdf0fdsaf110000
1fasdfsa
110000
2116.40717039.904690295.00
'''
略。。。
def RWXml(files,ssheet):
bk=xlrd.open_workbook(files)
sh=bk.sheet_by_name(ssheet)
nrows = sh.nrows
for i in range(1,nrows):
sss = sh.cell_value(i,2)
addr=sss.encode('gb2312')
citycode=int(sh.cell_value(i,3))
AC_result=XmlInfo(addr,citycode)#AC_result encoding=gbk
return AC_result.replace("GBK","utf-8")#AC_result encoding=gbk
def test(data):
dom = xml.dom.minidom.parseString(data)
root = dom.documentElement
table = dom.getElementsByTagName("obj")[0]
Cnode = table.getElementsByTagName("lon")[0]
for textnode in Cnode.childNodes:
return textnode.data
def test2(data):
notify_data_tree = Etree.fromstring(data)
str_value = notify_data_tree.find("obj/address").text
return str_value #>> i am title
abc = test(data)
print abc#单独调用ok,输入xml,输出xml的某节点
bbb = RWXml('testcase.xls','case')
print bbb#单独调用ok输出了xml
'''test函数传入RWXml函数,报错
lon = test(RWXml('testcase.xls','case'))
print lon
'''
只需要看最后几行就行了,两个函数单独调用没问题,但是某个函数以参数的形式传给另一个就报错,应该是字符集的问题,搞不定了
展开