[BUG] Old excel files are not supported.

[akshayjain3450]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

Error:

Exception in thread "main" org.apache.poi.hssf.OldExcelFormatException: The supplied spreadsheet seems to be Excel 5.0/7.0 (BIFF5) format. POI only supports BIFF8 format (from Excel versions 97/2000/XP/2003)

Expected Behavior

No response

Steps To Reproduce

Sample Spark Program:

def read(): Unit = {
  val df = spark.read.format("excel").load("examples/elsec09t.xls")
  df.show(10)
}

elsec09t.xls

Environment

- Spark version: 3.3.1
- Spark-Excel version: 3.3.1_0.18.5
- OS: MacOS

Anything else?

No response

[nightscape]

Nothing we can do here...
Please convert your Excel files a non-ancient version 😉