How to infer schema for Int column types about spark-excel HOT 3 CLOSED

I guess the problem is here:
https://github.com/crealytics/spark-excel/blob/master/src/main/scala/com/crealytics/spark/excel/InferSchema.scala#L78-L84
I copied that code from the spark-csv plugin, so it might need some tweaking.
If you want to give it a try you could adapt the part of the test where we specify which type should get inferred for numeric types and then try to fix the implementation.
Unfortunately, this won't get a high priority on our side until we run into that problem ourselves 😉

from spark-excel.

Thanks! I have one more question. I want to get RDD file, before changing it into dataframe. Is there any way to do this?. Maybe the result of buildscan?

from spark-excel.

Yes, if you instantiate an ExcelRelation yourself you should be able to use buildScan for that.

from spark-excel.