apache-sparkdatabricksazure-databricksspark-excelmaven-repository

How to select correct com.crealytics:spark-excel package in databricks

I am trying to install package com.crealytics:spark-excel package in databricks under maven repository. but the package installation is still in pending state. How to select com.crealytics:spark-excel package to install in databricks and on what basis. Can anyone please help me to understand.

All valuable suggestions are appreciated.

Thanks in advance

Solution

  • I have installed the com.crealytics:spark-excel_2.12:0.13.5

    Step 1: Navigate to the Cluster page and Compute in Databricks.

    Step 2: Click on the tab Libraries -> Install new.

    Step 3: Select Maven as a Library source

    enter image description here

    Step 4: Click on the Search packages

    enter image description here

    Step 5: Select the Maven central as in the below image enter image description here

    Step 6: Choose desired pacakge from the Maven Central based on the Scala and Spark version enter image description here

    For an example I have installed the bleow Vesrion. enter image description here

    enter image description here