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.
86%
off
Reg. price
$1512
Includes 41 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python
Bundle price $199
36 hours left at this price!
Learn the basic structure of Excel spreadsheets and how to open them in Python.
0% completed 0 of 5 exercises done
Discover how to get data from Excel sheets, cells, and selection areas using Python.
0% completed 0 of 17 exercises done
Add, modify, and delete data in Excel files.
0% completed 0 of 16 exercises done
Put your new skills to the test in these challenging exercises.
0% completed 0 of 7 exercises done
