task 0014 added

xkoko123 · xkoko123 · commit db3766d08c2d · 2014-12-09T10:23:53.000+08:00
diff --git a/agmcs/0014/0014.py b/agmcs/0014/0014.py
@@ -0,0 +1,17 @@
+#coding:utf-8
+import json
+import xlwt
+
+with open('student.txt','r')as f:
+    data = f.read().decode('gbk')
+data = json.loads(data)
+
+book =xlwt.Workbook(encoding = 'utf-8')
+sheet =book.add_sheet('student')
+
+for i in range(len(data)):
+    d = data[str(i+1)]
+    sheet.write(i,0,i+1)
+    for j in range(len(d)):
+        sheet.write(i,j+1,d[j])
+book.save('student.xls')
diff --git a/agmcs/0014/student.txt b/agmcs/0014/student.txt
@@ -0,0 +1,5 @@
+{
+    "1":["����",150,120,100],
+    "2":["����",90,99,95],
+    "3":["����",60,66,68]
+}
diff --git a/agmcs/0014/student.xls b/agmcs/0014/student.xls
