This article is written for intermediate developers who have a pretty good knowledge of Python data structures, such as dicts and lists, but also feel comfortable around OOP and more intermediate level topics.įirst things first, when would you need to use a package like openpyxl in a real-world scenario? You’ll see a few examples below, but really, there are hundreds of possible scenarios where this knowledge could come in handy. Create simple or more complex spreadsheets, including adding styles, charts, and so on.Manipulate Excel spreadsheets with confidence.In this article, you’ll learn how to use openpyxl to: That’s why they’re still so commonly used today.
Spreadsheets are a very intuitive and user-friendly way to manipulate large datasets without any prior technical background. Either it’s because your boss loves them or because marketing needs them, you might have to learn how to work with spreadsheets, and that’s when knowing openpyxl comes in handy! Watch it together with the written tutorial to deepen your understanding: Editing Excel Spreadsheets in Python With openpyxlĮxcel spreadsheets are one of those things you might have to deal with at some point. Watch Now This tutorial has a related video course created by the Real Python team.
0 kommentar(er)
