Course Content
Excel Automation with Python
Load Workbook
load_workbook() is a method provided by the openpyxl library in Python that allows you to load an existing Excel workbook from a file into memory. The load_workbook() method takes a filename as a parameter and returns a workbook object that represents the file's contents.
Task
Swipe to show code editor
- Load a workbook called
"sample_data.xlsx"; - Print the
sheetnames; - Print the active sheet.
Mark tasks as Completed
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
load_workbook() is a method provided by the openpyxl library in Python that allows you to load an existing Excel workbook from a file into memory. The load_workbook() method takes a filename as a parameter and returns a workbook object that represents the file's contents.
Task
Swipe to show code editor
- Load a workbook called
"sample_data.xlsx"; - Print the
sheetnames; - Print the active sheet.
Mark tasks as Completed
Switch to desktop for real-world practiceContinue from where you are using one of the options belowSection 1. Chapter 4
AVAILABLE TO ULTIMATE ONLY
