Unable to read excel file from Volume
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2025 08:04 AM
Hi, I'am trying to read excel file directly from Volume (not workspace or filestore) -> all examples on the internet use workspace or filestore. Volume is external location so I can read from there but I would like to read directly from Volume. I have confidential data - this is the reason to read data from Volume with secure access.
I'am using: com.crealytics:spark-excel_2.13:3.5.1_0.20.4 on 16.4 LTS cluster with scala 2.13
Code:
location = 'Volumes/directory1/file.xlsx'
df = (spark.read.format("com.crealytics.spark.excel") \
.option("header", "true") \
.option("inferSchema", "true") \
.load(location)
)
Error:
Failed to find the data source: com.crealytics.spark.excel. Make sure the provider name is correct and the package is properly registered and compatible with your Spark version. SQLSTATE: 42K02
