| 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 |
Summary
Refreshes a Microsoft Excel file in ArcGIS Pro.
Usage
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.
Parameters
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
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.