add 0017 0018 0019

Jaccorot · Jaccorot · commit eb89c63b1b0d · 2015-10-27T19:01:56.000+08:00
diff --git a/Jaccorot/0017/0017.py b/Jaccorot/0017/0017.py
@@ -0,0 +1,50 @@
+#!/usr/bin/python
+# coding=utf-8
+
+"""
+第 0017 题： 将 第 0014 题中的 student.xls 文件中的内容写到 student.xml 文件中，如
+
+下所示：
+
+<?xml version="1.0" encoding="UTF-8"?>
+<root>
+<students>
+<!--
+    学生信息表
+    "id" : [名字, 数学, 语文, 英文]
+-->
+{
+    "1" : ["张三", 150, 120, 100],
+    "2" : ["李四", 90, 99, 95],
+    "3" : ["王五", 60, 66, 68]
+}
+</students>
+</root>
+"""
+
+import xlrd
+import json
+from lxml import etree
+
+
+def read_exl(file_name):
+    exl = xlrd.open_workbook(file_name)
+    exl_sheet = exl.sheet_by_name('student')
+    data = {}
+    for i in range(exl_sheet.nrows):
+        data[exl_sheet.row_values(i)[0]] = exl_sheet.row_values(i)[1:]
+    return json.dumps(data, encoding='utf-8')
+
+def save_to_xml(data, new_file_name):
+    root = etree.Element('root')
+    students = etree.SubElement(root, 'students')
+    students.append(etree.Comment(u"""学生信息表 "id" : [名字, 数学, 语文, 英文]"""))
+    students.text = data
+
+    student_xml = etree.ElementTree(root)
+    student_xml.write(new_file_name, pretty_print=True, xml_declaration=True, encoding='utf-8')
+
+
+if __name__ == '__main__':
+    content = read_exl('student.xls')
+    save_to_xml(content, 'student.xml')
diff --git a/Jaccorot/0017/student.xls b/Jaccorot/0017/student.xls
diff --git a/Jaccorot/0017/student.xml b/Jaccorot/0017/student.xml
@@ -0,0 +1,4 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<root>
+  <students>{"1": ["\u5f20\u4e09", 150.0, 120.0, 100.0], "3": ["\u738b\u4e94", 60.0, 66.0, 68.0], "2": ["\u674e\u56db", 90.0, 99.0, 95.0]}<!--学生信息表 "id" : [名字, 数学, 语文, 英文]--></students>
+</root>
diff --git a/Jaccorot/0018/0018.py b/Jaccorot/0018/0018.py
@@ -0,0 +1,47 @@
+#!/usr/bin/python
+# coding=utf-8
+
+"""
+第 0018 题： 将 第 0015 题中的 city.xls 文件中的内容写到 city.xml 文件中，如下所示：
+
+<?xml version="1.0" encoding="UTF-8"?>
+<root>
+<citys>
+<!--
+    城市信息
+-->
+{
+    "1" : "上海",
+    "2" : "北京",
+    "3" : "成都"
+}
+</citys>
+</root>
+"""
+
+import xlrd
+import json
+from lxml import etree
+
+
+def read_exl(file_name):
+    exl = xlrd.open_workbook(file_name)
+    exl_sheet = exl.sheet_by_name('city')
+    data = {}
+    for i in range(exl_sheet.nrows):
+        data[exl_sheet.row_values(i)[0]] = exl_sheet.row_values(i)[1]
+    return json.dumps(data, encoding='utf-8')
+
+def save_to_xml(data, new_file_name):
+    root = etree.Element('root')
+    students = etree.SubElement(root, 'citys')
+    students.append(etree.Comment(u"""城市信息"""))
+    students.text = data
+
+    student_xml = etree.ElementTree(root)
+    student_xml.write(new_file_name, pretty_print=True, xml_declaration=True, encoding='utf-8')
+
+
+if __name__ == '__main__':
+    content = read_exl('city.xls')
+    save_to_xml(content, 'city.xml')
diff --git a/Jaccorot/0018/city.xls b/Jaccorot/0018/city.xls
diff --git a/Jaccorot/0018/city.xml b/Jaccorot/0018/city.xml
@@ -0,0 +1,4 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<root>
+  <citys>{"1": "\u4e0a\u6d77", "3": "\u6210\u90fd", "2": "\u5317\u4eac"}<!--城市信息--></citys>
+</root>
diff --git a/Jaccorot/0019/0019.py b/Jaccorot/0019/0019.py
@@ -0,0 +1,52 @@
+#!/usr/bin/python
+# coding=utf-8
+
+"""
+第 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
+import json
+from lxml import etree
+
+
+def read_exl(file_name):
+    exl = xlrd.open_workbook(file_name)
+    exl_sheet = exl.sheet_by_name('numbers')
+    data = []
+    for i in range(exl_sheet.nrows):
+        temp = [int(x) for x in exl_sheet.row_values(i) ]
+        data.append(temp)
+    return json.dumps(data, encoding='utf-8')
+
+def save_to_xml(data, new_file_name):
+    root = etree.Element('root')
+    students = etree.SubElement(root, 'numbers')
+    students.append(etree.Comment(u"""数字信息"""))
+    students.text = data
+
+    student_xml = etree.ElementTree(root)
+    student_xml.write(new_file_name, pretty_print=True, xml_declaration=True, encoding='utf-8')
+
+
+if __name__ == '__main__':
+    content = read_exl('numbers.xls')
+    save_to_xml(content, 'numbers.xml')
diff --git a/Jaccorot/0019/numbers.xls b/Jaccorot/0019/numbers.xls
diff --git a/Jaccorot/0019/numbers.xml b/Jaccorot/0019/numbers.xml
@@ -0,0 +1,4 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<root>
+  <numbers>[[1, 82, 65535], [20, 90, 13], [26, 809, 1024]]<!--数字信息--></numbers>
+</root>

-Original file line number
+Diff line change
@@ @@ -0,0 +1,4 @@ @@
 +<?xml version='1.0' encoding='UTF-8'?>
 +<root>
 +  <students>{"1": ["\u5f20\u4e09", 150.0, 120.0, 100.0], "3": ["\u738b\u4e94", 60.0, 66.0, 68.0], "2": ["\u674e\u56db", 90.0, 99.0, 95.0]}<!--学生信息表 "id" : [名字, 数学, 语文, 英文]--></students>
 +</root>