Menu
Is there a way to read an Excel file in Scala (xls not csv)? I mean are there any Scala libraries to do so?
856
(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!
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.
166
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
