OpenPyXL Blog

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()

Three steps:

• Import the module and create or open a workbook
• Data analysis and visualization
• Save and close the workbook

Sample code

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

ws = wb.create_sheet()
ws["A1"] = 0
ws.append([1, 2, 3])

wb.save('test.xlsx')
wb.close()

Advantages and Disadvantages of OpenPyXL Package

Advantages

• Does not rely on Excel, suitable for software development.
• Lightweight and flexible, supports object models, powerful functionality, OpenPyXL + pandas.
• Cross-platform.

Disadvantages

• Functionality is not as comprehensive as VBA.
• The entire operation process is invisible; results are only visible after saving and reopening.
• Cannot directly open .xls files.

Installing OpenPyXL Package

Online installation: pip install openpyxl

Offline installation: https://pypi.org/project/openpyxl/#files