Openpyxl Save Workbook

In this article you will learn how to save a workbook in python using openpyxl save() function. You may use "save" or "save as" option with the same function.

Syntax of save()

If you want to save a newly created file with a new name

file = "filename.xlsx"

workbook.save(file)

There are two options save and save as for existing files. If you want to save a file with save option use the old file name in save() function. In case you want to use save as option, use a new file name and save it.

Example 1: openpyxl save()

For a new excel workbook the example for saving a file is

>>> file = "newfile.xlsx"

>>> workbook.save(file)

As this is a new file and we are saving it for the first time, hence a new file name is created and provided to the save function. workbook is the workbook object we want to save.

Example 2: with "save" option

After editing or modifying an existing file, if you want to save it with save option write

>>> workbook.save("oldfilename.xlsx")

In this case simply use the old file name and the excel file will be modified, however you will not be able to access the old non-edited file.

Example 3: with "save as" option

If you want to save an existing file with a new name use save as option. 

>>> file = "newfilename.xlsx"

>>> workbook.save(file)

Use this option if you want to save the data as you will be saving in a new file and the old file will still be there and accessible.