title: Excel - Power query data refresh via Python
body: <p>I was trying to refresh a power query - external data in Excel via Python using following code</p>
  
  <pre><code>import win32com.client
  import time
  xl = win32com.client.DispatchEx("Excel.Application")
  wb = xl.workbooks.open(fileName)
  xl.Visible = True
  wb.RefreshAll()
  wb.Save()
  xl.Quit()
  </code></pre>
  
  <p>it works fine and serves the purpose, except, only for one time.
  The visibly open excel file closes but in task manager it is not being closed completely.
  Though I dont have much issue with that, except, when I try to run this for the next file, the 'Power Query' add-on stops loading, and I get error saying,
  The power query add-on need to be loaded in order to refresh this data.
   I have to go to task manager to close the excel.then,
  I have to go to options, (where power query add-on is already loaded), disable the add -on, close the excel, open again, re-load add-on .</p>
  
  <p>Please has anyone ever encountered this type of issue, or how to get out of it.
  my whole intention is to refresh some files in excel , with external data on a daily basis by some type of automation.</p>
  
  <p>Edit: Found the solution, add following line at the end of the code</p>
  
  <pre><code>import os
  os.system("taskkill /f /im excel.exe")
  </code></pre>
  
  <p>Thanks</p>