stnc-python
diff --git a/‎.DS_Store‎
0 Bytes b/‎.DS_Store‎
0 Bytes
diff --git a/‎Python tutorial - 18 - Read json file and save data to xlsx file/.idea/workspace.xml‎
Lines changed: 43 additions & 19 deletions b/‎Python tutorial - 18 - Read json file and save data to xlsx file/.idea/workspace.xml‎
Lines changed: 43 additions & 19 deletions
diff --git a/‎Python tutorial - 18 - Read json file and save data to xlsx file/input.json‎
Lines changed: 6 additions & 1 deletion b/‎Python tutorial - 18 - Read json file and save data to xlsx file/input.json‎
Lines changed: 6 additions & 1 deletion
diff --git a/‎Python tutorial - 18 - Read json file and save data to xlsx file/main.py‎
Lines changed: 3 additions & 12 deletions b/‎Python tutorial - 18 - Read json file and save data to xlsx file/main.py‎
Lines changed: 3 additions & 12 deletions
diff --git a/‎Python tutorial - 18 - Read json file and save data to xlsx file/output.xlsx‎
4.92 KB b/‎Python tutorial - 18 - Read json file and save data to xlsx file/output.xlsx‎
4.92 KB
diff --git a/‎Python tutorial - 18 - Read json file and save data to xlsx file/presentation.pages‎
8.11 KB b/‎Python tutorial - 18 - Read json file and save data to xlsx file/presentation.pages‎
8.11 KB
diff --git a/‎Python tutorial - 19 - Crawl web site data with Scrapy/.DS_Store‎
6 KB b/‎Python tutorial - 19 - Crawl web site data with Scrapy/.DS_Store‎
6 KB
diff --git a/‎Python tutorial - 19 - Crawl web site data with Scrapy/.idea/Python tutorial - 19 - Crawl web site data with Scrapy.iml‎
Lines changed: 11 additions & 0 deletions b/‎Python tutorial - 19 - Crawl web site data with Scrapy/.idea/Python tutorial - 19 - Crawl web site data with Scrapy.iml‎
Lines changed: 11 additions & 0 deletions
diff --git a/‎Python tutorial - 19 - Crawl web site data with Scrapy/.idea/misc.xml‎
Lines changed: 4 additions & 0 deletions b/‎Python tutorial - 19 - Crawl web site data with Scrapy/.idea/misc.xml‎
Lines changed: 4 additions & 0 deletions
diff --git a/‎Python tutorial - 19 - Crawl web site data with Scrapy/.idea/modules.xml‎
Lines changed: 8 additions & 0 deletions b/‎Python tutorial - 19 - Crawl web site data with Scrapy/.idea/modules.xml‎
Lines changed: 8 additions & 0 deletions
@@ -15,6 +15,11 @@
         {
             "x": 9,
             "y": 8
+        },
+
+        {
+            "x": 100,
+            "y": 120
         }
     ]
-}
+}
@@ -7,9 +7,6 @@ class FileManagement:
     def __init__(self):
         self.json_file_name = "input.json"
         self.excel_file_name = "output.xlsx"
-        self.reset_data()
-
-    def reset_data(self):
         self.array_x = []
         self.array_y = []
         self.array_sum = []
@@ -27,26 +24,20 @@ def read_text_file(self):
                     self.array_sum.append(x + y)
                     pprint.pprint("x = {0}".format(x))
                     pprint.pprint("y = {0}".format(y))
-
         except:
             print("Unexpected error : ", sys.exc_info()[0])
             raise
 
     def save_to_xlsx(self):
-        workbook = xlsxwriter.Workbook('demo.xlsx')
+        workbook = xlsxwriter.Workbook(self.excel_file_name)
         worksheet = workbook.add_worksheet()
-        worksheet.set_column('A:A', 20)
         for index, value in enumerate(self.array_x):
-            worksheet.write(index, 0, self.array_x[index])
-            worksheet.write(index, 1, self.array_y[index])
+            worksheet.write(index, 0, self.array_x[index]) #column 0
+            worksheet.write(index, 1, self.array_y[index]) #column 1
             worksheet.write(index, 2, self.array_sum[index])
-
         workbook.close()
 
 if __name__ == '__main__':
     file_management = FileManagement()
     file_management.read_text_file()
     file_management.save_to_xlsx()
-
-
-
Original file line number	Diff line number	Diff line change
`@@ -15,6 +15,11 @@`
`15`	`15`	`{`
`16`	`16`	`"x": 9,`
`17`	`17`	`"y": 8`
	`18`	`+ },`
	`19`	`+`
	`20`	`+ {`
	`21`	`+ "x": 100,`
	`22`	`+ "y": 120`
`18`	`23`	`}`
`19`	`24`	`]`
`20`		`-}`
	`25`	`+}`