Skip to content
Related Articles

Related Articles

Improve Article

Python Script to Automate Refreshing an Excel Spreadsheet

  • Difficulty Level : Medium
  • Last Updated : 14 Sep, 2021

In this article, we will learn how we can automate refreshing an Excel Spreadsheet using Python.

So to open the Excel application and workbooks we are going to use the pywin32 module. You can install the module using the below code:

 Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.  

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course

pip install pywin32

Then we are going to open the Excel application using the win32com.client.Dispatch() method and workbooks using the Workbooks.open() method.



Syntax: File.Workbooks.open(PATH_OF_FILE)

Parameters: It will take the path of the excel file as its parameter.

And then use refresh the file using RefershAll():

Workbook.RefreshAll()

For this example, we created an excel file named “Book1” with the below content:

Below is the implementation:

Python3




# Importing the pywin32 module
import win32com.client
  
# Opening Excel software using the win32com
File = win32com.client.Dispatch("Excel.Application")
  
# Optional line to show the Excel software
File.Visible = 1
  
# Opening your workbook
Workbook = File.Workbooks.open("Book1.xlsx")
  
# Refeshing all the shests
Workbook.RefreshAll()
  
# Saving the Workbook
Workbook.Save()
  
# Closing the Excel File
File.Quit()

Output:

My Personal Notes arrow_drop_up
Recommended Articles
Page :