Refresh Excel (Data Management Tools)

Summary

Refreshes a Microsoft Excel file in ArcGIS Pro.

When an Excel file is accessed through ArcGIS Pro, changes made to the file outside of ArcGIS Pro are not automatically reflected in the active session. This tool refreshes the Excel file so you see the most current version.
To use this tool, the Microsoft Access Database Engine driver must be installed on your computer.
Close Microsoft Excel before running this tool.

Label	Explanation	Data type
Input Excel File	The Excel file that will be refreshed.	File

Label	Explanation	Data type
Refreshed Excel File	The refreshed Excel file.	File

arcpy.management.RefreshExcel(in_excel_file)

Name	Explanation	Data type
in_excel_file	The Excel file that will be refreshed.	File

Name	Explanation	Data type
out_excel_file	The refreshed Excel file.	File

RefreshExcel example 1 (Python window)

Refresh an Excel file using the RefreshExcel function.

import arcpy
arcpy.management.RefreshExcel("C:\\MyProject\\MyExcelData.xls")

This tool does not use any geoprocessing environments.