AnsweredAssumed Answered

Open, Refresh Connections, Save, and Close Excel File

Question asked by boyle.matt on Aug 4, 2014
Latest reply on Aug 7, 2014 by tbu100

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!