title: Iterate each dropdown and read and save html table
body: <p>I am trying to iterate dropdown and then trying to read html table and want to save it in excel but I am getting an error:Tables not found</p>
  <pre><code>driver = webdriver.Chrome()
  
  driver.get('https://www.transferofvalue.ie/')
  a=['ABBVIE LTD','BAYER LTD','ASTRAZENECA']
  table = driver.page_source
  
  for i in a:
      select_box =driver.find_element_by_xpath(&quot;//*[@id='BodyContent__company']&quot;)
      select_box.send_keys(i)
      #time.sleep(10)
      ds=pd.read_html(table,index_col=None)[2]
      c=pd.DataFrame(ds)
      c.to_excel('ranking_{}.xlsx'.format(i),index=False)
  </code></pre>