title: Pandas - How to change values in the original excel workbook without changing the formatting
body: <p>I wanted to know is there a way to open an excel workbook through <strong>PANDAS</strong> update some values in the original file keeping all data validations, formulas and formatting <strong>as it was in the original file</strong> and save it?</p>
  
  <p>I can see similar question was posted here, but didn't got an answer and omits special fields:</p>
  
  <p><a href="https://stackoverflow.com/questions/48573622/pandas-to-change-the-colum-value-withoutchanging-the-format">pandas to change the colum value withoutchanging the format</a></p>
  
  <p>I do understand this can be done through writer as described here:</p>
  
  <p><a href="https://stackoverflow.com/questions/25479159/changing-formats-of-contents-in-columns-in-an-existing-excel-workbook">Changing formats of contents in columns in an existing Excel workbook</a></p>
  
  <p>but this would mean I need to redesign whole workbook in python with formatting, data validations countifs, etc which is just inhumane for the workbook I have to deal with. </p>
  
  <p>Can this be achieved?</p>