Refresh Excel External Data with Python
<p>I have an Excel file that I run a Python script on. The Excel file has external data connections that need to be refreshed before the Python script is run. The functionality I'm referring to is here:</p>

<p><a href="https://i.stack.imgur.com/W6EV5.png" rel="noreferrer"><img src="https://i.stack.imgur.com/W6EV5.png" alt="Refresh External Data"></a></p>

<p>I'm using Python 2.7 and am relying on Pandas for most of the Excel data parsing. </p>