Openpyxl close() Workbook

In this article you will learn how to close a workbook file in python using openpyxl close() function. 

Syntax of close()

The syntax to close an excel file in openpyxl is very simple i.e

workbook_object.close()

Here workbook object is the workbook which is open and now you want to close it. Its better to save the workbook before closing it.

If you want to Read, Write and Manipulate(Copy, cut, paste, delete or search for an item etc) Excel files in Python with simple and practical examples I will suggest you to see this simple and to the point Python Excel Course about Python and Excel files. You will learn the skill fast with illustrations and live code examples.

Everything you do in Microsoft Excel, can be automated with Python. So why not use the power of Python and make your life easy. You can make intelligent and thinking Excel sheets, bringing the power of logic and thinking of Python to Excel which is usually static, hence bringing flexibility in Excel and a number of opportunities

Example: Openpyxl close() function

An important thing to note is that close() function will close any file which is open in current python environment. Ofcourse, there is no need to close a file which is not open and already closed. 

>>> # First save the file

>>> workbook.save(file)

>>> workbook.close()

Close function will not take any argument. It will simply close the workbook object. After closing the file, you will not be able to access it until you open it again.