title: python excel subtract with 2 worksheet
body: <p>Is it possible to create a python script to automatic which is subtract cell value with 2 worksheet in one excel file?
  I have checked some documents, and seem that use the method of <strong>pandas</strong> or <strong>openpyxl</strong> to do so. But I can't to do that. Do you have any suggestion to me? Many thanks.</p>
  <p>Script:</p>
  <pre><code>from datetime import datetime
  import pandas as pd
  import openpyxl as xl;
  
  currDateTime = datetime.now()
  
  Sheet1 =&quot;C:\\Users\\peter\\Downloads\\&quot; + currDateTime.strftime('%Y%m%d') + &quot;\\5250A&quot; + &quot;\\5250A.xlsx&quot;
  wb3 = xl.load_workbook(Sheet1) 
  ws3 = wb3.worksheets[0] 
  wb4 = xl.load_workbook(Sheet1) 
  ws4 = wb4.worksheets[1] 
  wb5 = xl.load_workbook(Sheet1) 
  ws5 = wb5.create_sheet(&quot;Done&quot;)
  
  wb4.subtract(wb3)
  
  wb5.save(str(Sheet1)) 
  </code></pre>
  <p>Expected Result:</p>
  <p><img src="https://i.stack.imgur.com/tWs1c.png" alt="Figure1" />  <img src="https://i.stack.imgur.com/KG6fN.png" alt="Figure2" /> <img src="https://i.stack.imgur.com/fVlIb.png" alt="Figure3" /></p>