Using spark.read.excel – dataAddress with only start cell is not working (DBR 17.x)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2026 11:00 PM
Hi, has anyone successfully used the Databricks Runtime 17.x native Excel reader with a dataAddress containing only a start cell (no end cell)? Even in the documentation, it is not specified (https://learn.microsoft.com/en-us/azure/databricks/query/formats/excel).
Below code is not working
df = spark.read.format("excel").option("headerRows", 1).option("dataAddress", "Sheet1!A7").load(filepath)
In most scenarios, we don’t know the end cell address because both the number of rows and columns change for every file. How is the native Excel reader expected to help in these cases if dataAddress with only a start address (e.g. Sheet1!A7) does not automatically expand to the bottom‑right non‑empty cell?
