title: Update .xlsm file values python
body: <p>I have a .xlsm file as a reference template. I want to update the values of this .xlsm file using python from a .csv file.</p>
  
  <p>template .xlsm ----> Update values using .csv</p>
  
  <p>What has not worked : 
  I tried using pandas.to_excel method. but the .xlsm file gets corrupted after I write to sheet.</p>
  
  <p>Could someone please point me in the right direction ? </p>