Learn how to work with openpyxl, a popular Excel processing library in Python! Find out how to open, read, and write an Excel file in Python.
Python is a general-purpose language that allows you to perform various tasks related to programming and data science. Thanks to Python, you can freely process many different file formats including Excel and automate your daily work.
Excel, a spreadsheet application developed by Microsoft, is one of the most popular data exchange formats used by businesses and individuals. Most likely, you too are using Excel to record expenses, plan budgets, track progress, and complete many other tasks. Why not use Python to automate boring, everyday Excel-related tasks? Write some code that will do the work for you, and you will have more time to plan your next steps and strategies. Work more efficiently, because time is money!
“How to Read and Write Excel Files in Python” is an online course that introduces you to working with Excel files in Python. You'll learn how Excel files are built and how to work with them, with practical examples. You’ll learn how to process Excel files with openpyxl, a popular Python library that allows you to read and write Excel 2010 and later. We use Python version 3.0.4 for this course, but the features covered in the course are compatible with versions going back to 2.5.0.
In the course, we will first examine how Excel files are organized, and review some basic terminology related to Excel spreadsheets. After the introduction, we will explain how to read Excel files with openpyxl and how to process them in for loops. Finally, we will see how to create Excel files and modify their content in Python. In the final quiz, you’ll do several practical tasks on Excel files.
“How to Read and Write Excel Files in Python” is one of the courses from our Python File Processing track, where you'll learn to work with different file formats in Python. You can complete the courses from this track in whatever order you wish, since they don’t depend on each other. See what will be most useful to you! Remember that each course is a way to make your daily work easier.
Do you deal with Excel files at work? Then this skill is a must-have on your list.
Are you a data science beginner or a business professional performing data analysis using Excel files? Then this course is perfect for you!
Scroll down for an overview of the topics covered in this course, and for more about who all can benefit from it.
Learn the basic structure of Excel spreadsheets and how to open them in Python.
Discover how to get data from Excel sheets, cells, and selection areas using Python.
Add, modify, and delete data in Excel files.