Howto read Excel file in Scala [closed]

Is there a way to read an Excel file in Scala (xls not csv)? I mean are there any Scala libraries to do so?

How do I read XLS files in Databricks?

(1) login in your databricks account, click clusters, then double click the cluster you want to work with. to intall libs. (4) After the lib installation is over, open a notebook to read excel file as follow code shows, it can work!

How do I read an Excel file in Pyspark?

Read an Excel file into a pandas-on-Spark DataFrame or Series. Support both xls and xlsx file extensions from a local filesystem or URL. Support an option to read a single sheet or a list of sheets. The string could be a URL.

Try Apache POI, it's a Java library for reading most of Microsoft's document formats.