I am facing a problem in importing excel sheet in java application and intern inserting rows in oracle database.
One columns in excel sheet is holding numeric value and data length of that particular column is 17 digits.
Excel automatically converting the value of that column in some format (seems exponential) i.e. 12345678901234500 becomes 1.23E+16.
I am parsing this excel file and fetching cells in string, So when i try to ready 12345678901234500 value i get 1.23E+16 and as it is its getting inserted in database.
Does anybody faced similar problem ever? How do I retain or reformat this value. I dont have control over excel sheet so i can't format as its coming by import process from client.
Problem is with excel sheet. If I simply enter numeric value more than 10 to 12 digits without any cell formatting
it converts it some form. Its not a scientific notation, so i could not apply reverse formula as well.
Apache POI API would have helped me but I could not use that as well. It will make lots of classes to go in garbage and architectural changes.