Reading Excel files with Spark returns formula values instead of computed values
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2026 07:00 AM - edited 01-30-2026 07:05 AM
Hi,
I'm seeing inconsistent behavior when reading Excel files using the built-in connector Lakeflow Connector with spark.read.format("excel") (doc: https://docs.databricks.com/aws/en/query/formats/excel). I read an .xlsx file from S3 using this function a few days ago, and it returned computed/numeric values.
Today, running the exact same code against the exact same file path in S3 returns Excel formulas as strings instead (e.g., "=($B59+(K34/4.3))/K16"). The file has not been modified or re-uploaded in between.
Has anyone experienced similar behavior, or knows what could cause this? Could it be because the reader is still in beta?
Appreciate any help!
- Labels:
-
Spark