We have data in an Excel spreadsheet that is linked to a web xml file. This data contains lat/long positions which we use to convert the data into a feature class.
I already have a script created that will convert the data to a feature class, but to update the data within the spreadsheet, I need to manually open the Excel file, refresh all the data connections (4 different worksheets), save, and close.
I'm pretty new to python and am looking for a way to automate the process of opening, refreshing all data connections, saving, and closing an Excel file in order to fully automate this process.
Does anyone have a python example of opening, refreshing data connections, saving, and closing an Excel file?
Thanks in advance!