Read xlsx

Kolodziej

Hello,
why changes rapidminer values which are read in xlsx???
For example 20110201 in excel and 2.0110201E7 in rapidminer????
i need the number in integer to change it to a date.

i have tried to save the datasheet in xls, there were no problems. But why?

Nils_Woehler

Hi,

the numbers are exactly the same. But they are denoted in another way. 2.0110201E7 means 2.0110201 * 10 ^ 7 which is 20110201.
You can have a look here: http://en.wikipedia.org/wiki/Scientific_notation#E_notation
If you want to convert the number to date, try using the 'Numerical to Date' operator.

Best,
Nils