How to Automate Excel Work with Python using openpyxl | Learnerea
How to Automate Excel Work with Python using openpyxl | Learnerea
Python for automation videos playlist - Simplify it with Python
In this video we have covered -
00:00 - Introduction
01:43 - Summarizing with Pandas Pivot_Table and exporting in Excel
04:22 - Creating Workbook and Worksheet object with openpyxl
05:56 - Deleting Excel Rows using Python
07:26 - Unmerge Excel Merged cells using Python
08:35 - Writing into Excel Sheet Using Python
10:02 - Selecting and applying fill colour into row/multiple cells in an Excel Sheet
15:56 - Selecting and applying fill colour into column/multiple cells in an Excel Sheet
17:45 - Inserting multiple rows & columns in Excel sheet using Python
19:37 - Merging multiple cells in Excel sheet using Python
20:48 - Writing into merged cells in an Excel sheet using Python
21:30 - Alignment in Excel cells using Python
22:49 - Changing fill colour, font colour, font size, font style, font name in an Excel sheet using Python
27:30 - Apply border on range of cells/rows/columns into an Excel sheet using Python
31:56 - Freeze Panes into an Excel Sheet using Python
Download the script created in this video -
Script Name - automate_Excel_with_Python.py
GitHub URL - https://github.com/LEARNEREA/Python/t...
#Python #AutomatingExcelWithPython #Pythonprogramming #PythonTutorial #CombiningMultipleSheetsFromDifferentExcelFiles #Learnerea
