Reading Password protected excel(.xlsx) file in databricks

[RajibRajib_Mand]

I want to read password protected excel file and load the data delta table.Can you pleas let me know how this can be achieved in databricks?

[3vikram]

looks like no answer to this?

[igorsalo22]

df = spark.read.format("com.crealytics.spark.excel")\

  .option("dataAddress", "'Base'!A1")\

  .option("header", "true")\

  .option("workbookPassword", "test")\

  .load("test.xlsx")

display(df)