TechQA.

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

487 views Asked by Maheshnagakumar At 30 October 2023 at 16:02

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

There are 1 answers

DileeprajnarayanThumula

DileeprajnarayanThumula On 31 October 2023 at 07:22 BEST ANSWER

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