Want to know more about our Complete Python Course? Click the link below to secure your spot in the next class: https://lp.hashtagtreinamentos.com/es... TO DOWNLOAD THE FREE PYTHON MINI COURSE: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- ► Files Used in the Video: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/a... ----------------------------------------------------------------------- TO HIRE HASHTAG FOR YOUR COMPANY: https://www.hashtagtreinamentos.com/t... ----------------------------------------------------------------------- Hey Awesome! In today's class I'm going to show you how to automate Excel with Python! Exactly what you just read, we're going to create an Excel automation with Python using the openpyxl library. First, I'll show you how to do some operations using openpyxl, such as opening the file, getting the current tab, getting a cell, editing information... After that, we'll move on to the challenge of separating data in Excel, where the goal is to create a tab for each of the neighborhoods we have in the database and then separate all the information into their respective tabs! This is a type of automation that can save you a lot of time at work, especially if it's a task you do daily. It's important that you can automate this, even to be more efficient and be able to focus on other tasks in the company! ----------------------------------------------------------------------- Hashtag Programming ► Subscribe to our channel: http://bit.ly/3c0LJQi ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► Blog: https://bit.ly/2MRUZs0 ► YouTube: http://bit.ly/3c0LJQi ► Instagram: https://bit.ly/3o6dw42 ► Facebook: http://bit.ly/3qGtaF2 Here in the videos on the Hashtag Programação channel we teach several Python tips so that you can develop in this programming language and create your own projects and automations! ----------------------------------------------------------------------- Class Content 00:00 Introduction 01:38 Creating an empty file 01:55 Openpyxl (What it is and how it works) 03:37 Installing and importing openpyxl 05:00 How to load a file + precautions 06:58 Viewing Excel file tabs 07:40 Active tab in Excel 08:50 How to select a specific tab in Excel 10:06 How to select cells in Excel 12:47 How to edit a cell in Excel + save file 14:40 IMPORTANT Caution 15:35 How to find the last row in Excel? 18:06 Challenge to separate data in Excel 19:55 Importing the database 21:27 Last line filled in the database 27:54 Treatments when browsing the database 30:35 Create tab function 35:58 Function to transfer information to another tab 41:48 Copy library (copy and paste styles) 47:07 Conclusion #python #hashtagprogramming