Read actual cell values and not display values

sonaliag1 · June 22, 2011, 12:04pm

hi,

please let me know how to read actual values from cell (which is visible after clicking on cell)and not displayed value. let me know the settings for the same for xls and also for csv files.

amjad.sahi · June 22, 2011, 1:22pm

Hi,

I think you may use Cell.getStringValue()/getValue() method(s).

Thank you.

sonaliag1 · June 22, 2011, 1:31pm

No getStringValue/getValue won’t work. Both gives value as displayed and not actual value.

amjad.sahi · June 22, 2011, 2:01pm

Hi,

Please attached your template file and paste your sample code to show the issue, we will check it soon.

Thank you.