title: How to construct Dataframe from a Excel (xls,xlsx) file in Scala Spark?
body: <p>I have a large <code>Excel(xlsx and xls)</code> file with multiple sheet and I need convert it to <code>RDD</code> or <code>Dataframe</code> so that it can be joined to other <code>dataframe</code> later. I was thinking of using <a href="https://poi.apache.org/" rel="noreferrer">Apache POI</a> and save it as a <code>CSV</code> and then read <code>csv</code> in <code>dataframe</code>. But if there is any libraries or API that can help in this Process would be easy. Any help is highly appreciated.</p>