Editing Excel Spreadsheets in Python With openpyxl
Video: .mp4 (1920x1080, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 452 MB
Genre: eLearning Video | Duration: 16 lectures (1 hour, 13 mins) | Language: English
Excel spreadsheets are one of those things you might have to deal with at some point. Either it’s because your boss loves them or because marketing needs them, you might have to learn how to work with spreadsheets in Python, and that’s when knowing openpyxl comes in handy! Homepage: https://realpython.com/courses/editing-excel-python-openpyxl/
In this course, you’ll learn how to use openpyxl to:
Read Excel spreadsheets and iterate through the data
Manipulate speadsheet data using Python data structures
Create simple or more complex spreadsheets
Format workbooks using styles, filters, and conditional formatting
Enhance spreadsheets by adding images and charts
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.