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

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.

Tehtävä

Swipe to start coding

  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.

Ratkaisu

from openpyxl import Workbook

workbook = Workbook()
sheet = workbook.active

sheet["B1"] = "world!"

sheet["A1"] = "hello"

Mark tasks as Completed
Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 1. Luku 2
AVAILABLE TO ULTIMATE ONLY
some-alt