Reading Password protected excel(.xlsx) file in databricks
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-03-2022 03:36 AM
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?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2022 07:55 AM
looks like no answer to this?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2022 10:11 AM
df = spark.read.format("com.crealytics.spark.excel")\
.option("dataAddress", "'Base'!A1")\
.option("header", "true")\
.option("workbookPassword", "test")\
.load("test.xlsx")
display(df)
