Openpyxl Create Workbook()

In this article you will learn how to create a new workbook or excel file in python using openpyxl Workbook() function. The created workbook is empty with atleast one sheet in it. 

Syntax of Workbook()

First you need an import statement and then simply create a workbook reference object which points to the newly created excel file.

from openpyxl import Workbook

referenceobject = Workbook()

The import statement is only importing the Workbook class and later we create a workbook object to create a new workbook using Workbook() function.

Example: Workbook()

# import statement

>>>from openpyxl import Workbook

# create a new workbook

>>>mywb = Workbook()

# check type of object

>>>type(mywb)

<class 'openpyxl.workbook.workbook.Workbook'>

In this example a new workbook object mywb is created and its type is checked. The result shows that it is an openpyxl Workbook. This can be saved with a name and accessed later with that name.

A workbook is created with an active sheet, to access it use 

>>> mysheet = mywb.active