spark.databricks.sql.excel.enabled false at cluster level

der
Valued Contributor

Native databricks excel data source is GA
https://www.reddit.com/r/databricks/comments/1t4un82/native_excel_support_is_now_ga/
https://docs.databricks.com/aws/en/query/formats/excel

However, as long as it is not possible to read from another adress than A1 without specify a full range .option("dataAddress", "Sheet1!E10"), we stick to open source solution. However, it is not possible to deactivate the native databricks excel source on cluster level ☹️

Compute → <YOUR CLUSTER> → Configuration → Advanced → Spark spark.databricks.sql.excel.enabled false

spark.conf.get("spark.databricks.sql.excel.enabled")

'true'

If you do the same on notebook level, it works.

spark.conf.set("spark.databricks.sql.excel.enabled", "false")
spark.conf.get("spark.databricks.sql.excel.enabled")

'false'

EXCEL_DATA_SOURCE_NOT_ENABLED Excel data source is not enabled in this cluster 

@mmayorga