Hello everyone...!
Here i have a very interesting case.
I have 1 single xls file which is saved under Ms. Excel 2003.
The idea here is that the Tarikh Cell is using a Date Value; instead of Calculation.
Thus, I put the words; "
12/12/2001" ---> look at the preview above.
Very funny when I use the POI apache to read those line of cells...
It will read as calculation type. Which would return "
value : 37237.0" as a value, instead of a Date that I put as before.
Which portion that I should change in my source code, to get those numbers as A
STRING and not Calculation?
Correct me if I'm wrong. I guess it's the POI miss reading concept to obtain it, isn't?
Because If I try to eliminated the SWITCH Case at line 68; and strictly put the Reading
Then it will cause me an exception... because POI Detect that cells as Calculation. Is there any work around to avoid it?
I just want it to be readable in a STRING not a Calculation.
Anyway, here the
Java Class that I made to read the cell inside of it is posted in the source code below.
Okay here is my source code to read the cell from Row 5th ---> Index row is 4.