Openpyxl load_workbook()

In this article you will learn how to load or open a workbook in Python using openpyxl load_workbook() function. This method is used when you have to read or write to an existing excel file in Python. 

Syntax of load_workbook()

The syntax of load workbook function is 

This syntax will work if your existing excel file is in your current working directory. In case if you want to access a spreadsheet from anywhere on your computer you will provide a path to your file with full file name and extension. 

where path can be like 

"c:/myfiles/testfile.xlsx"

Example: load_workbook()

First example is when a file named uberdata.xlsx is in your current working directory and you want to open it or load it in python using openpyxl.

import openpyxl

mywb = openpyxl.load_workbook("uberdata.xlsx")

If excel file is not in your working directory, write full path of file with name and extension.

mywb = openpyxl.load_workbook("D:/datafiles/uberdata.xlsx")