Sumit Pawar

Results 3 comments of Sumit Pawar

I am also facing same issue on Azure Databricks and looking for possible solutions. Adding dependencies as per attachment but not working ![image](https://user-images.githubusercontent.com/21197434/146874759-d365b671-475d-4358-8485-c5d8f3572265.png)

To me it still didn't worked Steps followed :- 1. Added jar from dbfs ![image](https://user-images.githubusercontent.com/21197434/147227604-c6113e36-0b8b-46ee-bb5b-239dabe88831.png) 2. executed sample code ![image](https://user-images.githubusercontent.com/21197434/147227490-13af6cdd-8c2d-4f7e-92e5-832a4e9a5152.png)

Error trace ` NoClassDefFoundError: shadeio/commons/io/output/UnsynchronizedByteArrayOutputStream Caused by: ClassNotFoundException: shadeio.commons.io.output.UnsynchronizedByteArrayOutputStream at shadeio.poi.poifs.filesystem.FileMagic.valueOf(FileMagic.java:209) at shadeio.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:206) at shadeio.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:172) at com.crealytics.spark.excel.DefaultWorkbookReader.$anonfun$openWorkbook$1(WorkbookReader.scala:55) at scala.Option.fold(Option.scala:251) at com.crealytics.spark.excel.DefaultWorkbookReader.openWorkbook(WorkbookReader.scala:55) at com.crealytics.spark.excel.WorkbookReader.withWorkbook(WorkbookReader.scala:16) at com.crealytics.spark.excel.WorkbookReader.withWorkbook$(WorkbookReader.scala:15) at com.crealytics.spark.excel.DefaultWorkbookReader.withWorkbook(WorkbookReader.scala:50) at com.crealytics.spark.excel.ExcelRelation.excerpt$lzycompute(ExcelRelation.scala:32) at...