How To Create, Save and Close a Workbook Using OpenPyXL?

Method

Creating a Workbook Object:

import openpyxl as pyxl
wb = pyxl.Workbook()
# Or
from openpyxl import Workbook
wb = Workbook()

Saving a Workbook:

wb.save(‘test.xlsx’)

Saving As:

wb.save(‘test2.xlsx’)

Saving as a Template:

wb.template = True
wb.save(‘temp.xltx’)

Closing a Workbook:

wb.close()

Sample Code

#Creating, Saving, and Closing a Workbook

#Import the openpyxl package with alias pyxl
import openpyxl as pyxl

#Create a new workbook
wb=pyxl.Workbook()

#Or import the Workbook function
#from openpyxl import Workbook
#Create a new workbook
#wb=Workbook()

#Save the workbook
wb.save('test.xlsx')

#Save as a template
wb.template = True
wb.save('temp.xltx')

#Close the workbook
wb.close()