pyspark.sql.types.DecimalType about spark-excel HOT 5 CLOSED

Can you post a small example file and the actual calls that you made?

from spark-excel.

Well, i provide schema where one field is like:

        {
           'name': 'amount',
           'type': DecimalType(15, 2),
        },

At excel it's custom type like # ##0 "EUR". Just trying to show() dataframe. with FloatType everything is ok

from spark-excel.

Would you mind trying to debug this?
In order to do this, check the code out locally, put a breakpoint in ExcelRelation:114 and check what value actually makes it fail.

from spark-excel.

not sure....I'm using it from pyspark :(

from spark-excel.

The parsing of BigDecimal has been changed to use the underlying Double value.
We potentially lose some precision by that, but parsing BigDecimal as Strings didn't work out well.
Can you try the latest version and comment here if it doesn't work?
I'll close this issue until then because I think it should be solved.

from spark-excel.