Refresh Excel (Data Management)

Summary

Refreshes a Microsoft Excel file in ArcGIS AllSource.

Usage

• When an Excel file is accessed through ArcGIS AllSource, changes made to the file outside of ArcGIS AllSource 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.

Parameters

Dialog

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

Derived Output

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

Python

arcpy.management.RefreshExcel(in_excel_file)

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

Derived Output

Name	Explanation	Data Type
out_excel_file	The refreshed Excel file.	File

Code sample

RefreshExcel example 1 (Python window)

Refresh an Excel file using the RefreshExcel function.

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

Environments

This tool does not use any geoprocessing environments.