driscollis · driscollis · commit fe9ecff565b8 · 2020-07-09T10:58:39.000-05:00
add new remove sheets example
diff --git a/chapter38_excel/remove_sheets.py b/chapter38_excel/remove_sheets.py
@@ -0,0 +1,17 @@
+# remove_sheets.py
+
+import openpyxl
+
+def create_worksheets(path):
+    workbook = openpyxl.Workbook()
+    sheet1 = workbook.create_sheet()
+    # Insert a worksheet
+    workbook.create_sheet(index=1,
+                          title='Second sheet')
+    print(workbook.sheetnames)
+    workbook.remove(workbook['Second sheet'])
+    print(workbook.sheetnames)
+    workbook.save(path)
+
+if __name__ == '__main__':
+    create_worksheets('remove_sheets.xlsx')
