Reading Excel files with Spark returns formula values instead of computed values

bts136
Databricks Partner

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!