title: Create a Drop down list using XLWings in Python
body: <p>I have tried this code, but this is for validation. I want a code to create a new drop down menu.</p>
  <pre><code>
      app = xw.App(visible=True)
      wb = app.books.open('Test.xlsx')
      sht = wb.sheets['Sheet1']
      Formula1='&quot;Dog,Cat,Bat&quot;'
      dv = sht.range('A1').api.Validation.Formula1
  
  </code></pre>
  <p>I have tried using openpyxl it is working but it doesn't save a file when the file is open.</p>