How can I update a file on SharePoint with a Pandas or Pyspark dataframe from Databricks?
Is it possible or is the only option to upload the file from blob storage?
and if the upload is the only possible way, are there libraries to achieve that other than Office365-REST-Python-Client?
Unfortunately, you cannot read share point data in azure databricks. SharePoint is not supported source in azure databricks.
More information refer this Article.
Is there any alternative approach ?
yes, there are couple of alternative approaches:
Approach 1: Copy data from SharePoint online list by using azure data factory.
Approach 2: Using Python accessing SharePoint files and data .refer this SO thread by Karthick Mohanraj.
