Course Content
Excel: the Power of Openpyxl
Create Workbook
Workbook() is a function provided by the openpyxl library in Python that creates a new Excel workbook object. A workbook is the main container for all the data and information in an Excel file, including worksheets, charts, and macros.
The Workbook() function initializes a new workbook object and provides methods to create, modify, and save the workbook to a file. The workbook can have one or more worksheets, each containing a grid of cells arranged in rows and columns.
Task
- Import
Workbook
fromopenpyxl
; - Select the current active sheet (the
.active
attribute); - Insert
"hello"
in cell"A1"
.
Once you've completed this task, click the button above the code to check your solution.
Mark tasks as Completed
Everything was clear?
Section 1. Chapter 2
AVAILABLE TO ULTIMATE ONLY