Mahanatadattu
New Contributor II

val df = spark.read.format("com.crealytics.spark.excel")

.option("location", "dbfs:/FileStore/tables/Airline.xlsx")

.option("useHeader", "true")

.option("treatEmptyValuesAsNulls", "false")

.option("inferSchema", "false")

.option("addColorColumns", "false")

.load("dbfs:/FileStore/tables/Airline.xlsx")