I have the next problem...
I have a xlsx file with information to import.
I imported the information of the xlsx to a table of my database, I thought that the job was finished.
But I found that some numbers were rounded when the process readed the informacion of the xlsx.
I can't format the numbers because some values of columns has more decimal and someones less(the client want to see the value as in the xlsx file).
Also some cells have two or more numbers delimiter by "/", and other cells nothing.
The xlsx file is used in others process so I can't modify it :(
The columns of the table are varchar2(Oracle).
Some examples of the errors:
Excel === Database(imported information)
87.60 -> 87.60000...01
0.3600752 -> .36007520000...04
0.01200668 -> .012006679999...
0.3300 -> .32999...96
0.450 -> .44999...96
Information of my configuration file...
SELECT * FROM "Catalogo";
<script connection-id="oracleDB" if="rownum>1">
MY_TABLE (ID, COL_2, COL_3, COL_4, COL_5)
VALUES (?1, ?2, ?3, ?4, ?5);
I thought these possible solutions but I don't know if are possible...
Disable the round of the number with some configuration to do the inserts with the numbers without round.
Add some configuration to read the values of the cells as String to insert in the table the same information of the xslx file without problems.
I searched information about these topics but I can't found nothing that help me... :S
Did you have sometime this problem?
Thank you for your time! :)