Create 0015.py

llapuras · llapuras · commit 848386851908 · 2016-04-24T20:57:45.000+08:00
diff --git a/Liez-python-code/0015/0015.py b/Liez-python-code/0015/0015.py
@@ -0,0 +1,18 @@
+import re
+import xlwt
+
+def read2xls(x):
+    datatable = xlwt.Workbook(encoding = 'utf-8', style_compression = 0)
+    newsheet = datatable.add_sheet('student', cell_overwrite_ok = True)
+    num = 0
+    with open(x, 'r') as f:
+        text = f.read()
+        info = re.compile(r'"(\d+)" : "(.*?)"')
+        for x in info.findall(text):
+            for i in range(len(x)):
+                newsheet.write(num, i, x[i])
+            num += 1
+
+        datatable.save('liez.xls')
+
+read2xls('student.txt')
