Skip to content

Commit a0951dd

Browse files
committed
add ex0017, 0018 and 0019
1 parent 647392c commit a0951dd

9 files changed

Lines changed: 130 additions & 0 deletions

File tree

‎GitRangerLiu/0017/excel_to_xml.py‎

Lines changed: 44 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,44 @@
1+
# -*- coding: utf-8 -*-
2+
3+
import xlrd
4+
from lxml import etree
5+
import json
6+
import io
7+
8+
fromfile = 'student.xls'
9+
10+
def read_xls(fromfile):
11+
book = xlrd.open_workbook(fromfile)
12+
sheet = book.sheet_by_name('student')
13+
data = {}
14+
rows = sheet.nrows
15+
cols = sheet.ncols
16+
kv = []
17+
for i in range(rows):
18+
for j in range(1, cols):
19+
if type(sheet.cell_value(i, j)) is float:
20+
kv.append(int(sheet.cell_value(i, j)))
21+
else:
22+
kv.append(sheet.cell_value(i, j))
23+
data[str(int(sheet.cell_value(i, 0)))] = kv
24+
return json.dumps(data, ensure_ascii = False)
25+
26+
def to_xml(data):
27+
#Create a document and elements
28+
root = etree.Element('root')
29+
stu = etree.SubElement(root, 'student')
30+
#Create a comment
31+
stu.append(etree.Comment(u' 学生信息表\n\t"id" : [名字, 数学, 语文, 英文]'))
32+
33+
#Create text
34+
stu.text = data
35+
36+
#Save to file
37+
tree = etree.ElementTree(root)
38+
tree.write('student.xml', encoding = 'utf-8', pretty_print = True, \
39+
xml_declaration = True)
40+
41+
if __name__ == '__main__':
42+
data = read_xls(fromfile)
43+
to_xml(data)
44+

‎GitRangerLiu/0017/student.xls‎

5.5 KB
Binary file not shown.

‎GitRangerLiu/0017/student.xml‎

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,5 @@
1+
<?xml version='1.0' encoding='UTF-8'?>
2+
<root>
3+
<student>{"1": ["张三", 150, 120, 100, "李四", 90, 99, 95, "王五", 60, 66, 68], "3": ["张三", 150, 120, 100, "李四", 90, 99, 95, "王五", 60, 66, 68], "2": ["张三", 150, 120, 100, "李四", 90, 99, 95, "王五", 60, 66, 68]}<!-- 学生信息表
4+
"id" : [名字, 数学, 语文, 英文]--></student>
5+
</root>

‎GitRangerLiu/0018/city.xls‎

5.5 KB
Binary file not shown.

‎GitRangerLiu/0018/city.xml‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
<?xml version='1.0' encoding='UTF-8'?>
2+
<root>
3+
<cities>{"1": "上海", "3": "成都", "2": "北京"}<!--城市信息--></cities>
4+
</root>

‎GitRangerLiu/0018/excel_to_xml.py‎

Lines changed: 37 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,37 @@
1+
# -*- coding: utf-8 -*-
2+
import json
3+
import xlrd
4+
from lxml import etree
5+
6+
testfile = 'city.xls'
7+
savename = 'city.xml'
8+
sheetname = 'big city'
9+
10+
def to_xml(data):
11+
root = etree.Element('root')
12+
stu = etree.SubElement(root, 'cities')
13+
comm = etree.Comment(u'城市信息')
14+
stu.append(comm)
15+
16+
stu.text = data
17+
tree = etree.ElementTree(root)
18+
tree.write(savename, encoding = 'utf-8', pretty_print = True, \
19+
xml_declaration = True)
20+
21+
def read_excel(testfile):
22+
book = xlrd.open_workbook(testfile)
23+
sheet = book.sheet_by_name(sheetname)
24+
data = {}
25+
rows = sheet.nrows
26+
cols = sheet.ncols
27+
for i in range(rows):
28+
data[str(int(sheet.cell_value(i, 0)))] = sheet.cell_value(i, 1)
29+
#The ensure_ascii param is very important for Chinese character, see the
30+
#document
31+
return json.dumps(data, ensure_ascii = False)
32+
33+
34+
if __name__ == '__main__':
35+
data = read_excel(testfile)
36+
to_xml(data)
37+

‎GitRangerLiu/0019/excel_to_xml.py‎

Lines changed: 36 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,36 @@
1+
# -*- coding: utf-8 -*-
2+
import json
3+
import xlrd
4+
from lxml import etree
5+
6+
testfile = 'numbers.xls'
7+
savename = 'numbers.xml'
8+
sheetname = 'number'
9+
10+
def to_xml(data):
11+
root = etree.Element('root')
12+
stu = etree.SubElement(root, 'numbers')
13+
comm = etree.Comment(u'数字信息')
14+
stu.append(comm)
15+
16+
stu.text = data
17+
tree = etree.ElementTree(root)
18+
tree.write(savename, encoding = 'utf-8', pretty_print = True, \
19+
xml_declaration = True)
20+
21+
def read_excel(testfile):
22+
book = xlrd.open_workbook(testfile)
23+
sheet = book.sheet_by_name(sheetname)
24+
data = []
25+
rows = sheet.nrows
26+
cols = sheet.ncols
27+
for i in range(rows):
28+
line = [int(sheet.cell_value(i, j)) for j in range(cols)]
29+
data.append(line)
30+
return json.dumps(data)
31+
32+
33+
if __name__ == '__main__':
34+
data = read_excel(testfile)
35+
to_xml(data)
36+

‎GitRangerLiu/0019/numbers.xls‎

5.5 KB
Binary file not shown.

‎GitRangerLiu/0019/numbers.xml‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
<?xml version='1.0' encoding='UTF-8'?>
2+
<root>
3+
<numbers>[[1, 82, 65535], [20, 90, 13], [26, 809, 1024]]<!--数字信息--></numbers>
4+
</root>

0 commit comments

Comments
 (0)