title: fill formula in Excel column and row automatically using python
body: <p>I am in process of automating the excel report using python and stuck in this step.Any input is greatly appreciated. i have one formula which applied to Cell AN5 =(F5-B5)/F5. On excel, I would just drag the formula to the rest of the cells to all the columns(till BK) to apply the formula . Can you please tell how to do it in python like drag function in excel. i want the formula to be applied from AN5 TO AN13(vertically) and til BK5(horizontally)</p>
  <p>If AN5=(F5-B5)/F5 then A06 = should fill with formula (G5-C5)/G5 and so on. Please help me to complete the automation. i have went through some referenced link but dint work as per this requirement.</p>
  <p><a href="https://i.stack.imgur.com/auIrj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/auIrj.png" alt="enter image description here" /></a></p>