complete 0015

starlightme · starlightme · commit 380c76924699 · 2015-02-27T02:21:46.000+08:00
diff --git a/Jimmy66/0015/0015.py b/Jimmy66/0015/0015.py
@@ -0,0 +1,34 @@
+#!/bin/env python
+# -*- coding: utf-8 -*- 
+
+#导入模块
+import simplejson as json  
+import xlwt
+
+#从文件(JSON形式)中读取数据返回字典
+def read_file(filename):
+    with open(filename,'r') as fp:
+        content = fp.read()
+    d = json.JSONDecoder().decode(content)
+    return d  
+
+#生成对应的xls文件
+def gen_xls(d,filename):
+    fp = xlwt.Workbook()
+    table = fp.add_sheet('city',cell_overwrite_ok=True)
+    #这次一次循环就可以了
+    for n in range(len(d)):
+        table.write(n,0,n+1)
+        table.write(n,1,d[str(n+1)])
+    fp.save('city.xls')
+    print '写入完毕'
+
+#主函数
+def main():
+    filename = 'city.txt'
+    xls_name = 'city.xls'
+    d = read_file(filename)
+    gen_xls(d,xls_name)
+
+if __name__ == '__main__':
+    main()
diff --git a/Jimmy66/0015/city.txt b/Jimmy66/0015/city.txt
@@ -0,0 +1,5 @@
+{
+    "1" : "上海",
+    "2" : "北京",
+    "3" : "成都"
+}
diff --git a/Jimmy66/0015/city.xls b/Jimmy66/0015/city.xls
