Excel with Python: Working with Excel Spreadsheets from Python

Python 3.7
  • 13 Videos | 1h 22m 11s
  • Includes Assessment
  • Earns a Badge
Likes 86 Likes 86
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

  • Playable
    1. 
    Course Overview
    2m 5s
    UP NEXT
  • Playable
    2. 
    Manipulating data with Microsoft Excel
    4m 9s
  • Locked
    3. 
    Manipulating Excel spreadsheets using openpyxl
    7m 37s
    FREE ACCESS
  • Locked
    4. 
    Accessing Data in openpyxl
    7m 47s
    FREE ACCESS
  • Locked
    5. 
    Manipulating Rows and Columns
    5m 19s
    FREE ACCESS
  • Locked
    6. 
    Writing to Files
    7m 11s
    FREE ACCESS
  • Locked
    7. 
    Manipulating Data in Files
    6m 24s
    FREE ACCESS
  • Locked
    8. 
    Freezing Rows and Columns
    8m 23s
    FREE ACCESS
  • Locked
    9. 
    Filtering Data
    8m 5s
    FREE ACCESS
  • Locked
    10. 
    Sorting Data
    6m 20s
    FREE ACCESS
  • Locked
    11. 
    Resizing Rows and Columns
    6m 33s
    FREE ACCESS
  • Locked
    12. 
    Merging Rows and Columns
    5m 33s
    FREE ACCESS
  • Locked
    13. 
    Course Summary
    1m 16s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Inserting & Manipulating Data
Likes 71 Likes 71  
COURSE Python - Using Pandas for Visualizations and Time-Series Data
Likes 66 Likes 66  
COURSE Python Development: Getting Started with Programming in Python
Likes 0 Likes 0  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Getting Started with Python: Introduction
Likes 1602 Likes 1602  
COURSE Complex Data Types in Python: Working with Dictionaries & Sets in Python
Likes 464 Likes 464  
COURSE Automation Testing for Python
Likes 48 Likes 48