This video demonstrates how to insert & delete columns & rows in Excel using Python's library Openpyxl. I use Anaconda's Jupyter Lab interface.

😄 Please consider supporting this channel and making this content possible:
☕ [ Ссылка ]
🅿 [ Ссылка ]

00:00 :: Intro and workbook review
00:20 :: Importing load_workbook and grab sheet
00:45 :: insert_cols to insert columns
00:53 :: doc string review
01:28 :: insert_cols with the amount argument, inserting 5 columns
02:05 :: delete_cols to remove columns
02:35 :: delete_cols with the amount argument, removing 5 columns
02:50 :: insert_rows
03:05 :: delete_rows
03:25 :: Overview

#PythonExcelTutorial #openpyxl #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #data #jupyterlab

свернуть