Course Content
Excel Automation with Python
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
Workbookfromopenpyxl; - Select the current active sheet (the
.activeattribute); - Insert
"hello"in cell"A1".
Once you've completed this task, click the button above the code to check your solution.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
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
Workbookfromopenpyxl; - Select the current active sheet (the
.activeattribute); - Insert
"hello"in cell"A1".
Once you've completed this task, click the button above the code to check your solution.
Switch to desktop for real-world practiceContinue from where you are using one of the options below