title: Update Excel Spreadsheet with Real-Time Python Data
body: <p>I'm quite new to Python and have mostly targeted learning the language exactly to automate some processes and update / populate excel spreadsheets with realtime data. Is there a way (e.g. through openpyxl) to update specific cells with data that's extracted through python packages such as pandas or web scraping through BeautifulSoup ?</p>
  
  <p>I already have the necessary code to extract the data-series that I need for my project in Python but am stuck entirely on how to link this data to excel.</p>
  
  <pre><code>import pandas as pd
  import pandas_datareader.data as web
  import datetime as dt
  
  start = dt.datetime(2000,1,1)
  end = dt.datetime.today()
  
  tickers = [
      "PYPL",
      "BABA",
      "SAP"
  ]
  
      df = web.DataReader (tickers, 'yahoo', start, end)
  
  print (df.tail(365)['Adj Close'])
  </code></pre>