Python Tutoring Online
 Home            

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

Non Computer Science Background Students

We Specialize in teaching and tutoring Python from intro to advanced modules like Pandas and Machine learning to Non Programming and Non computer science Python learners.

If you are not from CS We will train you that there will be no difference between your Python skills and CS programmers Python skills.

Join Now

Python Programming online tutors


Python Programming for Beginners

Python for Advanced Level

for University Python Programming Course

for Practical tasks at work

Python Projects Help & Guidance

Automating your computing tasks


Learn Python, Advance in your Career Join Now

For More information

Python Trainings Online


Python for Non Programmers Training

Machine Learning for Beginners Training

Deep Learning for Beginners Training

Python Pandas Training Tutors

Numpy, Matplotlib, Scipy Tutors

Keras, Tensorflow, Theano Tutors


Flexible and Tailored for your Specific Needs

More info on Trainings

Python Online Training Features


Live (1 on 1) Python Tutoring at Skype

Learn Practical Examples

Work on Python Projects

High Quality Training from Experts

You may select your Syllabus for Tutoring

Flexible Timings: Select time which suits you


Guaranteed Learning

Join Course

PythonTutor.net

Home    Tutorial     Online Live Trainings    Contact Us           © 2020 All rights reserved by www.PythonTutor.net