Excel with Python: Working with Excel Spreadsheets from Python
Python 3.7
| Intermediate
- 13 videos | 1h 16m 41s
- Includes Assessment
- Earns a Badge
This 13-video course explores how Microsoft Excel spreadsheets can be created, opened, and modified programmatically from within Python. Learners will review the Microsoft Excel object model, the attributes of the worksheet cell object which can be leveraged to create and modify workbooks programmatically. First, you will review VBA (Visual Basic for Applications) technology, before exploring how Python and its ecosystem of libraries are fast emerging as a popular choice for easy spreadsheet automation. Then you will learn how to use openpyxl (open pixel library) to manipulate Excel's object model programmatically from within Python. Continue by learning how to write spreadsheets by using openpyxl, and examining how existing Excel workbooks can be opened, as well as how new spreadsheet files can be created, and written out to disk. Finally, you will learn how Python iterators and indexing can be used to access and manipulate individual cells, ranges consisting of many cells, as well as entire rows and columns.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this course
create a Microsoft Excel workbook by choosing from a list of templates
create a Microsoft Excel workbook using the openpyxl library
access individual cells programmatically using openpyxl
access entire rows and columns and manipulate them programmatically
save the contents of an in-memory representation to a Microsoft Excel file on disk
use lists and other Python containers to read to and write from Excel files -
specify rows and columns that always ought to be on-screen as a user browses an Excel file
filter data in a range based on various attributes
sort data in a range using different columns and sort criteria
customize the size of rows and columns to enhance readability
merge and unmerge groups of cells
summarize the key concepts covered in this course
IN THIS COURSE
-
2m 5s
-
4m 9sIn this video, you will learn how to create a Microsoft Excel workbook by choosing from a list of templates. FREE ACCESS
-
3. Manipulating Excel spreadsheets using openpyxl7m 37sIn this video, you will create a Microsoft Excel workbook using the openpyxl library. FREE ACCESS
-
4. Accessing Data in openpyxl7m 47sIn this video, you will access individual cells programmatically using openpyxl. FREE ACCESS
-
5. Manipulating Rows and Columns5m 19sIn this video, find out how to access entire rows and columns and manipulate them programmatically. FREE ACCESS
-
6. Writing to Files7m 11sLearn how to save the contents of an in-memory representation to a Microsoft Excel file on disk. FREE ACCESS
-
7. Manipulating Data in Files6m 24sDuring this video, you will learn how to use lists and other Python containers to read from and write to Excel files. FREE ACCESS
-
8. Freezing Rows and Columns8m 23sAfter completing this video, you will be able to specify rows and columns that always should be on-screen as a user browses an Excel file. FREE ACCESS
-
9. Filtering Data8m 5sIn this video, find out how to filter data in a range based on various attributes. FREE ACCESS
-
10. Sorting Data6m 20sTo sort data in a range using different columns and sort criteria: FREE ACCESS
-
11. Resizing Rows and Columns6m 33sIn this video, learn how to resize rows and columns to enhance readability. FREE ACCESS
-
12. Merging Rows and Columns5m 33sLearn how to merge and unmerge groups of cells. FREE ACCESS
-
13. Course Summary1m 16s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
