Not able to read excel from hadoop location about spark-excel HOT 5 CLOSED

Ah, sorry, I didn't update the README for version 0.8.3.
Try that version, it should be able to read from Hadoop because of this: #5

from spark-excel.

Hi,

When i am trying to use 0.8.3 api as suggested by you for any column x i am getting an additional column x_color. Can you please help me, how can i remove these unnecessary columns.

sample schema generated by your API:

root
|-- name: string (nullable = true)
|-- age: double (nullable = true)
|-- location: string (nullable = true)
|-- salary: double (nullable = true)
|-- name_color: string (nullable = true)
|-- age_color: string (nullable = true)
|-- location_color: string (nullable = true)
|-- salary_color: string (nullable = true)

from spark-excel.

See the addColorColumns option in the README.

from spark-excel.

Getting this exception when trying to fetch the first row out of data frame
xyz.xlsx

PFA the excel file.

root
|-- name: string (nullable = true)
|-- age: double (nullable = true)
|-- location: string (nullable = true)
|-- salary: double (nullable = true)

Exception in thread "main" java.lang.RuntimeException: Unknown cell type 2 for TRUE()
at com.crealytics.spark.excel.ExcelRelation$$anonfun$1$$anonfun$3.apply(ExcelRelation.scala:66)
at com.crealytics.spark.excel.ExcelRelation$$anonfun$1$$anonfun$3.apply(ExcelRelation.scala:60)
at com.crealytics.spark.excel.ExcelRelation$$anonfun$1$$anonfun$apply$2.apply(ExcelRelation.scala:82)
at com.crealytics.spark.excel.ExcelRelation$$anonfun$1$$anonfun$apply$2.apply(ExcelRelation.scala:77)
at com.crealytics.spark.excel.ExcelRelation$$anonfun$5$$anonfun$apply$3.apply(ExcelRelation.scala:86)
at com.crealytics.spark.excel.ExcelRelation$$anonfun$5$$anonfun$apply$3.apply(ExcelRelation.scala:86)
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244)
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244)

Code:
DataFrame df = sqlContext.read().format("com.crealytics.spark.excel").option("location", "hdfs://localhost:54310/home/impadmin/xyz.xlsx")
.option("sheetName", "Sheet1").option("useHeader", "true").option("treatEmptyValuesAsNulls", "true").option("inferSchema", "true")
.option("addColorColumns", "false").load();
System.out.println("************ " + df.first());

from spark-excel.

Hey @raviuiit, can you create a new issue if it's a different problem?

from spark-excel.