title: How to Watch Excel File Change While openpyxl Makes Changes
body: <p>I built an iOS app that takes users' inputs then uploads their data as .csv files onto dropbox.</p>
  
  <p>Now, I'd like to build a cross-platform desktop app that uses openpyxl and the Python dropbox api to listen for these .csv uploads and then write the data in these .csv files to various .xlsx workbooks. I have no issues with this, except my client wants to be able to watch on their desktop as the excel workbooks change.</p>
  
  <p>Whenever I make an assignment with openpyxl, such as...</p>
  
  <pre><code>wb = load_workbook("sample.xlsx") #load an existing .xlsx file
  ws = wb.active #get active worksheet
  ws['A1'] = 12 #assign data to cell A1
  </code></pre>
  
  <p>... then running this script will successfully alter the file, BUT I have to close and then open the file to see the change, instead of watching the change happen as it happens.</p>
  
  <p>So, my question is, how do I watch openpyxl's changes to excel workbooks happen as they occur, and is there a cross-platform solution for this? Alternate ways of approaching the problem are appreciated!</p>
  
  <p>My research on this has spanned a few hours and the best I have come up with is some hybrid of AppleScript and pywin32, but that could get real ugly/buggy real fast!</p>
  
  <p>I much appreciate the help!</p>