title: How to change one Excel cell value using python and read a column values related to this cell with formula?
body: <p>I should iterate the value of a cell in an Excel file, lets say A5 from 1 to 100</p>
  
  <p>and for each value, I should read the values of a column like C1 to C10 that are related  to the value of A5 by a formula. </p>
  
  <p>I wanted to know, should I change the value in A5 and save and close the file and re open and read it or there is a better way to do so ?</p>