第 0017 题： 将 第 0014 题中的 student.xls 文件中的内容写到 student.xml 文件中，如
下所示：
<?xml version="1.0" encoding="UTF-8"?>
<root>
<students>
{
"1" : ["张三", 150, 120, 100],
"2" : ["李四", 90, 99, 95],
"3" : ["王五", 60, 66, 68]
}
</students>
</root>
import xlrd
from xml.etree.ElementTree import Element, SubElement, Comment, ElementTree
wb = xlrd.open_workbook(r'file\stu.xls')
sh = wb.sheet_by_index(0)
data = dict()
for rx in range(sh.nrows):
row = sh.row(rx)
value_list = list()
key = row[0].value
for i in row[1:]:
value = i.value
value_list.append(value)
data[key] = value_list
print(data)
root = Element('root')
comment = Comment('学生信息表"id" : [名字, 数学, 语文, 英文]')
root.append(comment)
child = SubElement(root, 'students')
child.text = str(data)
tree = ElementTree(root)
tree.write('file\\student22.xml', encoding='utf8')
第 0018 题： 将 第 0015 题中的 city.xls 文件中的内容写到 city.xml 文件中，如下所示：
<?xmlversion="1.0" encoding="UTF-8"?>
<root>
<citys>
{
"1" : "上海",
"2" : "北京",
"3" : "成都"
}
</citys>
</root>
import xlrd
from xml.etree.cElementTree import Element, ElementTree, Comment, SubElement
wb = xlrd.open_workbook('file\\city.xls')
ws = wb.sheet_by_index(0)
data = dict()
for rx in range(ws.nrows):
row = ws.row(rx)
key = row[0].value
value = row[1].value
data[key] = value
root = Element('root')
comment = Comment('城市信息')
root.append(comment)
child = SubElement(root, 'citys')
child.text = str(data)
tree = ElementTree(root)
tree.write('file\\city.xml', encoding='utf8')
第 0019 题： 将 第 0016 题中的 numbers.xls 文件中的内容写到 numbers.xml 文件中，如下
所示：
<?xml version="1.0" encoding="UTF-8"?>
<root>
<numbers>
[
[1, 82, 65535],
[20, 90, 13],
[26, 809, 1024]
]
</numbers>
</root>
import xlrd
from xml.etree.cElementTree import Element, ElementTree, SubElement, Comment
wb = xlrd.open_workbook('file\\num.xls')
ws = wb.sheet_by_index(0)
content = list()
for xr in range(ws.nrows):
row = ws.row(xr)
num_list = list()
for i in row:
value = i.value
num_list.append(value)
content.append(num_list)
print(content)
root = Element('root')
comment = Comment('数字信息')
root.append(comment)
child = SubElement(root, 'numbers')
child.text = str(content)
tree = ElementTree(root)
tree.write('file\\num.xml', encoding='utf8')
