title: Using shareplum to edit excel file on Sharepoint with Python
body: <p>I have a dataframe I'm trying to upload to an existing excel document on Sharepoint. Based on a previous question I posted, I was advised that the shareplum library could achieve this. Going through the documentation though (<a href="https://shareplum.readthedocs.io/en/latest/objects.html#get_file" rel="nofollow noreferrer">https://shareplum.readthedocs.io/en/latest/objects.html#get_file</a>) and I don't see any way of inserting the dataframe. Before I tried using this function:</p>
  <p><code>df.to_excel(r'Path where the exported excel file will be stored\File Name.xlsx', sheet_name='Your sheet name', index = False)</code></p>
  <p>But this did not work (I think it gave an access denied error). Is there a way to achieve the same function with shareplum as the above line? i.e. automatically insert the dataframe into sheet1 and if sheet1 doesn't exist then create it.  All I've managed to follow from the documentation is the authentication with office 365 part.</p>