At first I was thinking you could use an immediate calculation Attribute Rule to accomplish this but Arcade cannot be used to directly access MS Excel files or monitor changes. As @RyanUthoff mentioned, likely Python could do this. I used an AI assistant on the Esri Support website to write this Python example below. Likely you'll need to change and test the workflow to see if it works as intended. but it's a starting point.
import pandas as pd
import arcpy
import os
import time
# Paths
excel_file = r"C:\Temp\TEMP.xlsx" # Replace with your Excel file path
sde_connection = r"C:\Temp\GISOWNER@TEMP.sde" # Replace with your connection file
feature_class = "TEMP.YourFeatureClass" # Replace with your feature class name
field_to_update = "NAME" # Replace with the field name in your eGDB.
# Function to update the enterprise geodatabase
def update_geodatabase_from_excel():
# Read Excel file
df = pd.read_excel(excel_file, sheet_name="TEMP")
# Assuming the Excel file has a column 'NAME' and a unique identifier 'ID'
name_dict = dict(zip(df['ID'], df['NAME']))
# Update the geodatabase
with arcpy.da.UpdateCursor(os.path.join(sde_connection, feature_class), ['ID', field_to_update]) as cursor:
for row in cursor:
if row[0] in name_dict:
row[1] = name_dict[row[0]]
cursor.updateRow(row)
# Monitor the Excel file for changes
last_modified_time = os.path.getmtime(excel_file)
while True:
current_modified_time = os.path.getmtime(excel_file)
if current_modified_time != last_modified_time:
update_geodatabase_from_excel()
last_modified_time = current_modified_time
time.sleep(5) # Check every 5 seconds
