Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Create Workbook | Excel Automation with Python (project)
Excel Automation with Python (project)
course content

Course Content

Excel Automation with Python (project)

test

Swipe to show menu

book
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
test

Swipe to show code editor

  1. Import Workbook from openpyxl;
  2. Select the current active sheet (the .active attribute);
  3. Insert "hello" in cell "A1".

Once you've completed this task, click the button above the code to check your solution.

Solution

Mark tasks as Completed
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 1. Chapter 2
AVAILABLE TO ULTIMATE ONLY
We're sorry to hear that something went wrong. What happened?
some-alt