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

LabelExplanationData Type
Input Excel File

The Excel file that will be refreshed.

File

Derived Output

LabelExplanationData Type
Refreshed Excel File

The refreshed Excel file.

File

arcpy.management.RefreshExcel(in_excel_file)
NameExplanationData Type
in_excel_file

The Excel file that will be refreshed.

File

Derived Output

NameExplanationData 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.

Related topics