Using Library facing errors source org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:103

[achyuthe]

Does this library will work in cluster mode?

Why i am getting this error?
Failed to read zip entry source org.apache.poi.openxml4j.opc.ZipPackage.(ZipPackage.java:103

[nightscape]

This sounds like you're trying to read a different file format than .xlsx, e.g. .xls.
To check, you could try downloading the file, renaming it to .zip and extract it with some archiving tool.

[achyuthe]

@nightscape

execution steps,
Took excel from test cases of the project

spark2-shell --queue usx.core --deploy-mode client --jars spark-excel_2.11-0.10.2.jar

val file = "hdfsPath/88/plain_number.xlsx"

val data = spark.read.format("com.crealytics.spark.excel").option("useHeader","false").option("sheetName", "Sheet1").load(file)

Error

va.lang.NoClassDefFoundError: org/apache/poi/ss/usermodel/WorkbookFactory
at com.crealytics.spark.excel.ExcelRelation$$anonfun$openWorkbook$2$$anonfun$apply$4.apply(ExcelRelation.scala:66)
at com.crealytics.spark.excel.ExcelRelation$$anonfun$openWorkbook$2$$anonfun$apply$4.apply(ExcelRelation.scala:66)
at scala.Option.fold(Option.scala:158)

[nightscape]

Can you update to 0.13.7? That's the newest version published for Scala 2.11.

[achyuthe]

@nightscape Thanks for the response.
Made the changes a

spark2-shell --queue usx.core --deploy-mode client --jars spark-excel_2.11-0.13.7.jar
val file = "/hdfsPath/88/plain_number.xlsx"
park.read.format("com.crealytics.spark.excel").option("sheetName", "Sheet1").option("header", "true").option("inferSheetSchema", "true").load(file)
java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException
at shadeio.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:97)
at shadeio.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:147)
at shadeio.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:256)
at shadeio.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:221)
at com.crealytics.spark.excel.DefaultWorkbookReader$$anonfun$openWorkbook$1.apply(WorkbookReader.scala:49)
at com.crealytics.spark.excel.DefaultWorkbookReader$$anonfun$openWorkbook$1.apply(WorkbookReader.scala:49)
at scala.Option.fold(Option.scala:158)
at com.crealytics.spark.excel.DefaultWorkbookReader.openWorkbook(WorkbookReader.scala:49)
at com.crealytics.spark.excel.WorkbookReader$class.withWorkbook(WorkbookReader.scala:14)
at com.crealytics.spark.excel.DefaultWorkbookReader.withWorkbook(WorkbookReader.scala:45)
at com.crealytics.spark.excel.ExcelRelation.excerpt$lzycompute(ExcelRelation.scala:32)
at com.crealytics.spark.excel.ExcelRelation.excerpt(ExcelRelation.scala:32)
at com.crealytics.spark.excel.ExcelRelation.headerColumns$lzycompute(ExcelRelation.scala:104)
at com.crealytics.spark.excel.ExcelRelation.headerColumns(ExcelRelation.scala:103)
at com.crealytics.spark.excel.ExcelRelation$$anonfun$inferSchema$1.apply(ExcelRelation.scala:172)
at com.crealytics.spark.excel.ExcelRelation$$anonfun$inferSchema$1.apply(ExcelRelation.scala:171)
at scala.Option.getOrElse(Option.scala:121)
at com.crealytics.spark.excel.ExcelRelation.inferSchema(ExcelRelation.scala:171)
at com.crealytics.spark.excel.ExcelRelation.(ExcelRelation.scala:36)
at com.crealytics.spark.excel.DefaultSource.createRelation(DefaultSource.scala:36)
at com.crealytics.spark.excel.DefaultSource.createRelation(DefaultSource.scala:13)
at com.crealytics.spark.excel.DefaultSource.createRelation(DefaultSource.scala:8)
at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:340)
at org.apache.spark.sql.DataFrameReader.loadV1Source(DataFrameReader.scala:239)
at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:227)
at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:174)
... 49 elided
Caused by: java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlException
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 75 more

Attaching the excel file

plain_number.xlsx

[nightscape]

Hi @achyuthe, this doesn't have anything to do with the file itself.
Thanks for posting it though, that's often the missing piece of information 😉
I don't have time to look into this, but could you check if one of the open issues matches yours, or provides an approach to a solution?
https://github.com/crealytics/spark-excel/search?q=ClassNotFoundException&type=issues