topic Re: Reading Password protected excel(.xlsx) file in databricks in Data Engineering

Reading Password protected excel(.xlsx) file in databricks

RajibRajib_Mand — Mon, 03 Jan 2022 11:36:03 GMT

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 — Wed, 23 Nov 2022 15:55:04 GMT

looks like no answer to this?

igorsalo22 — Wed, 30 Nov 2022 18:11:12 GMT

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

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

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

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

.load("test.xlsx")

display(df)