title: Load an excel file (office 365) with python
body: <p>I'd like to load an excel file which is located on my office 365 (education pack). After the data(frame) transformation I want to save the result on my office 365.</p>
  
  <p>Today I have the following code on my local computer</p>
  
  <pre><code>import numpy as np
  import pandas as pd
  
  df=pd.read_excel('/Users/xxxx/OneDrive.../cdm-test.xlsx ',sheetname='Form1')
  ...
  df.to_excel('xxxx-dataclean.xlsx',sheet_name='Sheet1')
  DOM_PRO.to_excel('xxxxx_PRO_dataclean.xlsx',sheet_name='Sheet1')
  </code></pre>
  
  <p>1- How can I read an excel file directly on office 365 (/test/cdm-test.xlsx) ?<br>
  2- How can I write 2 new Excel files directly on my office 365 ?</p>
  
  <p>I read a lot of articles but nothing works as I want.</p>
  
  <p>I hope you can help me</p>
  
  <p>Olivier</p>