FerArribas
Contributor

Hi @Hubert Dudek​,

Pandas API doesn't support abfss protocol.

You have three options:

  • If you need to use pandas, you can write the excel to the local file system (dbfs) and then move it to ABFSS (for example with dbutils)
  • Write as csv directly in abfss with the Spark API (without using pandas)
  • Write the dataframe as excel with the Spark API directly in abfss with a library like https://github.com/crealytics/spark-excel. (without using pandas)

Thanks.

Fernando Arribas