Welcome to another video! In this video, I will cover how we can use python to automate Excel. I’ll be going over everything from creating workbooks to accessing individual cells and stylizing cells. There is a ton of things that you can do with Excel but I’ll just be covering the core/base things in OpenPyXl.

📄 Resources 📄
OpenPyXL Docs: https://openpyxl.readthedocs.io/en/stable/
Code Written in This Tutorial: https://github.com/techwithtim/ExcelPythonTutorial
Fix Pip (Windows): https://www.youtube.com/watch?v=AdUZArA-kZw
Fix Pip (Mac/Linux): https://www.youtube.com/watch?v=E-WhAS6qzsU&t=4s

⭐️ Timestamps ⭐️

• 00:00 | Introduction
• 02:14 | Installing openpyxl
• 03:19 | Testing Installation
• 04:25 | Loading an Existing Workbook
• 06:46 | Accessing Worksheets
• 07:37 | Accessing Cell Values
• 08:58 | Saving Workbooks
• 09:52 | Creating, Listing and Changing Sheets
• 11:50 | Creating a New Workbook
• 12:39 | Adding/Appending Rows
• 14:26 | Accessing Multiple Cells
• 20:46 | Merging Cells
• 22:27 | Inserting and Deleting Rows
• 23:35 | Inserting and Deleting Columns
• 24:48 | Copying and Moving Cells
• 26:06 | Practical Example, Formulas & Cell Styling

#python #excel