commit 0016

darcycool · darcycool · commit d42a7ca8fad9 · 2017-08-25T16:38:07.000+08:00
diff --git a/darcycool/0016/numbers.txt b/darcycool/0016/numbers.txt
@@ -0,0 +1,5 @@
+[
+	[1, 82, 65535],
+	[20, 90, 13],
+	[26, 809, 1024]
+]
diff --git a/darcycool/0016/numbers.xls b/darcycool/0016/numbers.xls
diff --git a/darcycool/0016/write_into_excel.py b/darcycool/0016/write_into_excel.py
@@ -0,0 +1,20 @@
+# -*- coding: utf-8 -*-
+# 第 0016 题： 纯文本文件 numbers.txt, 里面的内容（包括方括号），请将上述内容写到 numbers.xls 文件中
+import collections
+import json
+
+import xlwt
+
+with open('numbers.txt', 'r') as f:
+    data = json.load(f)
+    print(data)
+
+wb = xlwt.Workbook()
+ws = wb.add_sheet('number')
+
+for index, item in enumerate(data):
+    for j, value in enumerate(item):
+        print(index, j, value)
+        ws.write(index, j, value)
+
+wb.save('numbers.xls')
